topic Re: Qlikview Sheet hide based on two field values in QlikView

Qlikview Sheet hide based on two field values

Wed, 28 Oct 2015 12:27:49 GMT

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,

Re: Qlikview Sheet hide based on two field values

marcus_malinow — Wed, 28 Oct 2015 13:54:13 GMT

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

Re: Qlikview Sheet hide based on two field values

Kushal_Chawda — Wed, 28 Oct 2015 14:04:38 GMT

try below condition,

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

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

Re: Qlikview Sheet hide based on two field values

Thu, 29 Oct 2015 06:23:49 GMT

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

Re: Qlikview Sheet hide based on two field values

Thu, 29 Oct 2015 06:39:35 GMT

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

Re: Qlikview Sheet hide based on two field values

marcus_malinow — Thu, 29 Oct 2015 15:49:32 GMT

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...

Re: Qlikview Sheet hide based on two field values

Fri, 30 Oct 2015 08:41:39 GMT

Thanks a lot Marcus !!!

Its working fine for me now.