topic Re: Conditional Object in QlikView

Conditional Object

Tue, 15 Jul 2014 22:14:05 GMT

Hello,

i want to hide a text if there are currently no selections in the worksheet. Can you please guide me? thanks.

Re: Conditional Object

Tue, 15 Jul 2014 22:24:10 GMT

You could create a text object and go to properties>layout and create a conditional show:

=if(GetCurrentSelections() >1,1,0)

See below:

Hope that helps,

Matt

Re: Conditional Object

Wed, 16 Jul 2014 00:11:40 GMT

Thanks Matthew,

just a follow up question, what if i wanted the text box to show based on a certain field and only when it is selected?

Re: Conditional Object

Wed, 16 Jul 2014 00:49:21 GMT

You could use this:

=if(GetFieldSelections(YourField) >1,1,0)

Re: Conditional Object

Wed, 16 Jul 2014 01:33:58 GMT

Thank you once again, this works great but i have to click on the value for that particular field. I have a bar chart and i would like it that soon as a user narrows the selection down to a single field the text box should show up.

Re: Conditional Object

Wed, 16 Jul 2014 01:42:06 GMT

Ok, in that case this should work:

=if(GetCurrentSelections() >=1,1,0)

If not, don't hesitate to upload a qvw showing what you want, may be simpler way to get exactly what you need.

Matt

Re: Conditional Object

NZFei — Wed, 16 Jul 2014 02:45:05 GMT

=if(getpossiblecount(YourField)=1,1,0)

Re: Conditional Object

parthiband — Wed, 16 Jul 2014 03:54:55 GMT

Hi faisalac3,

Try closing the post, once ur problem got resolved.

It will be useful the one, who comes in and searches for the same question of yours

Thanks