How to reference Customised Dimension in Listbox for alternate state?

Wed, 10 Dec 2014 01:46:01 GMT

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

topic How to reference Customised Dimension in Listbox for alternate state? in QlikView