Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to check if value selected

I have a box called monthName     that contains    Dec 2012, Jan 2013 , Feb 2013

I have a column in pivot table for Dec 2012 but i want to hide this if dec 2012 is not selected

I need the formula to be put in conditional so that if i select multiple dates and Dec 2012 is one of the selection to show the column

else hide it

3 Replies

You can use SubStringCount(GetFieldSelections(FieldName, ',', 100), 'Dec 2012')

MVP & Luminary
MVP & Luminary


Use Enable conditonal for dimension Dec 2012, and use this condition

=SubStringCount(GetFieldSelections(FieldName, ',', 100), 'Dec 2012') > 0

If you select Dec 2012, then the dimension will be shown, otherwise it is hidden.



Not applicable

Unfortunately this method with SubStringCount would not work, if the desired value is contained in another value.

Example: There is a selected value 'Another Dec 2012', but 'Dec 2012' is not selected. SubStringCount would deliver a return value > 0.

Therefore we would beter choose a set analysis:

=Count({$<FieldName*={'Value'}>}FieldName) > 0

In your case:

=Count({$<monthName*={'Dec 2012'}>}monthName) > 0