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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
renjithpl
Specialist
Specialist

Layout - Show -Conditional

HI All,

I have a field called Reviewmodes, now i have a variable called Vcost. I want to show the variable if modes='Review Mode'.

So i gave a formula like this -

Reviewmodes='Managed Review' it worked. But i also want to show if i press Clear button.

My formula says if i select the reviewmodes then it will display.

How can i achieve..

THanks in advance

Ranjit

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

There might be a simpler way, but I'm thinking this might work:

only({<Reviewmodes*={'Managed Review'}>} Reviewmode)='Managed Review'

The idea is that we use set analysis to intersect the possible Reviewmodes with 'Managed Review'. If managed review is possible, then the result should be managed review. If it isn't possible, then the result should be null. We detect if the result is managed review, which should tell us if managed review is possible based on the selections, even if it isn't directly selected.

View solution in original post

1 Reply
johnw
Champion III
Champion III

There might be a simpler way, but I'm thinking this might work:

only({<Reviewmodes*={'Managed Review'}>} Reviewmode)='Managed Review'

The idea is that we use set analysis to intersect the possible Reviewmodes with 'Managed Review'. If managed review is possible, then the result should be managed review. If it isn't possible, then the result should be null. We detect if the result is managed review, which should tell us if managed review is possible based on the selections, even if it isn't directly selected.