topic Re: Using Show Conditional in QlikView

Using Show Conditional

Anonymous — Fri, 07 Nov 2014 21:17:03 GMT

So I have two objects that I want to lay over each other. The point is to make the user make a selection of a zip code before the values are present. So once a zip code is selected the zip code object disappears and the other object is visible. I was using

Count ([Zip Code]) = 1

but it didn't seem to be working for me. I am new to this function of qlikview and am hoping someone can assist.

Thanks

Re: Using Show Conditional

danieloberbilli — Fri, 07 Nov 2014 21:23:28 GMT

in chart properties Object1: Layout tab > Show Condition: getselectedcount([Zip Code])=0

in chart properties Object2: Layout tab > Show Condition: getselectedcount([Zip Code])>0

Re: Using Show Conditional

Anonymous — Mon, 10 Nov 2014 02:24:22 GMT

Daniel,

Thanks so much. What if I want to add multiple fields and I wanted the functionality to be if the user picked any of these functions then the data (graphs,charts, etc.) would show up?

Re: Using Show Conditional

danieloberbilli — Mon, 10 Nov 2014 02:57:08 GMT

you could list all the fields with OR like this:

GetSelectedCount(Field1)>0 OR GetSelectedCount(Field2)>0 OR...