Functions which basically operate on current selection state like
GetFieldSelections, GetPossibleCount will not take parameter as Alternative states.
some thing like GetFieldSelections(<State1> Field1) is not possible in Qlikview 11.
Instead we can use general functions like Maxstring, Concat, Count functions.
For example if we want to know selection made in a field which has an alternative state and have 'Allways one selection'.
In this case for accessing the selection made in that field we can use.
maxstring({[State1]} [Field1]).
If allways one selections is disabled and for getting all selections we can use.
=concat({[State1]} distinct [Field1],'|')
For getting Selection count we can use.
=count({[State1]} distinct [Field1])
Hope it helps :)
GetFieldSelections, GetPossibleCount will not take parameter as Alternative states.
some thing like GetFieldSelections(<State1> Field1) is not possible in Qlikview 11.
Instead we can use general functions like Maxstring, Concat, Count functions.
For example if we want to know selection made in a field which has an alternative state and have 'Allways one selection'.
In this case for accessing the selection made in that field we can use.
maxstring({[State1]} [Field1]).
If allways one selections is disabled and for getting all selections we can use.
=concat({[State1]} distinct [Field1],'|')
For getting Selection count we can use.
=count({[State1]} distinct [Field1])
Hope it helps :)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.