Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Try this:

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

View solution in original post

3 Replies
Highlighted

Try this:

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

View solution in original post

Highlighted

Read about the parameters within GetFieldSelections here: GetFieldSelections ‒ QlikView

Highlighted
Contributor II
Contributor II

Thanks Sunny T - this worked perfectly