topic Layout - Show -Conditional in QlikView

Layout - Show -Conditional

renjithpl — Fri, 19 Nov 2010 13:48:26 GMT

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

Layout - Show -Conditional

johnw — Sat, 20 Nov 2010 02:09:17 GMT

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.