Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to reference Customised Dimension in Listbox for alternate state?

Hi All,

I have the following customised expression in my field list box edited as followed:

=PICK(WildMatch(QuestionType,'ABC','*'),null(),QuestionType)

This particular list box is also using an alternate state: [Group 1]

Problem:  I need to set the calculation conditions in a chart to show the result when at least one question type is chosen.

Previously, I am using GetSelectedCount() and I have found out that this function won't work with alternate state.

So how do i input into my calculated conditions so that it can work on this 2 things:

1.  Refer to my customised expression which does not have any label except objectID.

2.  Include alternate states in this calculation condition so that Qlikview will understand where to get this selection.

Any advice is much appreciated.

Thanks

Chun Wey

0 Replies