Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
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
CELAMBARASAN
Partner - Champion
Partner - Champion

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

jagan
Luminary Alumni
Luminary Alumni

HI,

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.

Regards,

Jagan.

Not applicable
Author

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