Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
siobhancrossen
Contributor II
Contributor II

Disappearing Conditional Expressions in straight table...

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

1 Solution

Accepted Solutions
sunny_talwar

Try this:

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

View solution in original post

3 Replies
sunny_talwar

Try this:

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

sunny_talwar

Read about the parameters within GetFieldSelections here: GetFieldSelections ‒ QlikView

siobhancrossen
Contributor II
Contributor II
Author

Thanks Sunny T - this worked perfectly