Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional expression issue

Hi All,

In my qv application I have created a straight table as the attached sample. The conditional expression that I have used for individual month field is  For example jan =SubStringCount(GetFieldSelections(Month,',',100),'Jan')>0 and GetFieldSelections(Quarter) <> 'Q2'

and GetFieldSelections(Quarter) <> 'Q3' and GetFieldSelections(Quarter) <> 'Q4'

pic1.png

But when I select any combination of quarter like Q2 and Q3, the output is like All the months are displayed with Q1 and Q4 months with 0 and Q2 , Q3 months with data. The output is correct but I don’t want Q1, Q4 to be displayed, since we are selecting only Q2 and Q3. This is for all possible Quarter

combination.

pic2.png

Kindly provide a solution.

Regards,

Gerard

1 Reply
swuehl
MVP
MVP

Gerard,

I just posted a suggested solution to your other post. Please try not to duplicate threads, this makes it hard to follow a discussion.

Regards,

Stefan