Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
Index(GetFieldSelections(REPORT_CRITERIA_E_DESC, ',', 1000000),'Regulation Exceptions')>0
Try this:
Index(GetFieldSelections(REPORT_CRITERIA_E_DESC, ',', 1000000),'Regulation Exceptions')>0
Read about the parameters within GetFieldSelections here: GetFieldSelections ‒ QlikView
Thanks Sunny T - this worked perfectly