Qlikview Sheet hide based on two field values

[#1]

HI All,

I am trying to hide a sheet based on two values/flag.

Field1='N'

Field2='1'

If i apply condition on conditional visible expressing its not hiding the sheet,

Below is the expression I am using,

=Field1='N' and Field2='1'

Kindly suggest.

Thanks,

[marcus_malinow]

I'm assuming here that in order for the sheet to display, these values should be selected.

In which case, change your expression to

Only(Field1)='N' and Only(Field2)=1

[Kushal_Chawda]

try below condition,

if(Field1='N' and Field2='1',0,1)

Go to Settings-> Document Properties-> Security-> uncheck show all sheets & objects

[#4]

Hi Kuch, I have tried above but still not working.

Below is my scenario,

the table data look like below,

Field1	Field2
Y	1
Y	2
Y	3
Y	4
N	5
N	6

I have 6 sheets in the QVW.

e.g, I only want to show sheet 1 if Field1='Y' and Field2='1'

Similarly I wanted to hide sheet 6 if Field1='N' and Field2='6'

Thanks

Nishant

[#5]

Hi Marcus, I have tried above but still not working.

Below is my scenario,

the table data look like below,

Field1	Field2
Y	1
Y	2
Y	3
Y	4
N	5
N	6

I have 6 sheets in the QVW.

e.g, I only want to show sheet 1 if Field1='Y' and Field2='1'

Similarly I wanted to hide sheet 6 if Field1='N' and Field2='6'

Thanks

Nishant

[marcus_malinow · Accepted solution]

Ok, so you'll have slightly different conditions for each sheet.

For sheet 1:

only({$<Field2={'1'}>} Field1)='Y'

For sheet 2:

only({$<Field2={'2'}>} Field1) = 'Y'

etc..etc..etc...

[#7]

Thanks a lot Marcus !!!

Its working fine for me now.