Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
New Contributor III

Count the selections in Alternate state

Dear all,


I'm quite new in working with Alternate states and yet I have a problem that I think is easy to solve but somehow I cannot get the solution to it.

I want to create a label which will do the following:

If anything selected in the Alternate filter selection --> Show the name of the value selected in the filter

If nothing selected --> show '-'

Now, the first IF is solved with MaxString({[Location State 2]} Field 1) but when nothing is selected into the Alternate state filter [Location State 2] it will still show the longest string in Field 1.

Is there any way to solve this?

Best regards,