topic Re: Conditional Show of Sheet in QlikView

Conditional Show of Sheet

Fri, 02 Oct 2015 17:59:17 GMT

Hi,

I was trying to Hide/Show a sheet based on the selection of a Field in a listbox(alternatestate)....looks like its not working

Condition Used: =if(Flag>0,'NO','YES')....it gives the right output in a text box,but when I use the same logic to conditionally show the sheet its not working.

if(Flag>0,1,0)

Any thoughts?

Re: Conditional Show of Sheet

hic — Fri, 02 Oct 2015 18:25:19 GMT

Use

=Flag>0

HIC

Re: Conditional Show of Sheet

sudeepkm — Fri, 02 Oct 2015 18:35:18 GMT

you do not need to write if condition again in a conditional box. conditional box is designed to take the condition expression.

so if you are expecting to show the Sheet when Flag is non zero then you can just use Flag <> 0 in your Sheet's properties condition box

Re: Conditional Show of Sheet

Fri, 02 Oct 2015 18:48:15 GMT

Thanks for the prompt reply...it worked!!!