Disappearing Conditional Expressions in straight table...

[siobhancrossen]

Hi

I have been working on an 'ad hoc' report builder in Qlikview.  It is a straight table with 17 different Conditional Expressions which are switched on and off using a list box based on an inline table.  When I have more than 6 options selected from the listbox, the conditional columns in my straight table all disappear.  I have already set my user preferences for 'Max Values in Current Selection Box' to 99 so I know this isn't the problem

This is the format criteria I am using for each conditional expression - REPORT_CRITERIA_E_DESC stays the same for all with the field value changing for each of the 17 options

index(GetFieldSelections(REPORT_CRITERIA_E_DESC),'Regulation Exceptions')>0

Any help would be very much appreciated!

Thank you

[sunny_talwar · Accepted solution]

Try this:

Index(GetFieldSelections(REPORT_CRITERIA_E_DESC, ',', 1000000),'Regulation Exceptions')>0

[sunny_talwar]

Read about the parameters within GetFieldSelections here: GetFieldSelections ‒ QlikView

[siobhancrossen]

Thanks Sunny T - this worked perfectly