topic hidding columns in QlikView

hidding columns

Tue, 21 Feb 2012 10:00:01 GMT

hi all,

i have a question about hidding columns.

this is what i did, i know that i am in the right direction but i am dont know what is wrong:

this is my list box:

list box: Hide BY

GETSelectedcount(cost)=1

GETSelectedcount(clicks)=1

i set new variable called VshowCOST:

=GetFieldSelections("Hide By")

in the main chart properties i put a condition with the variable $(VshowCOST)

when i click in the list box on one of the items, both columns(cost and clicks) are dissapearing and i want only what the user is choosing hidden.

what is the problem?

thank you

hidding columns

Anonymous — Tue, 21 Feb 2012 12:55:48 GMT

If you can please attached some example file . is used to understand your requirement clearly

Regards

hidding columns

Tue, 21 Feb 2012 13:34:13 GMT

Hi,

It seems to me that now whatever you're choosing in the Hide By listbox - if the condition is true it's true for both of your columns, and therefore both of them are hidden.

If I understood what you need correctly, I would load in the Hide By listbox:

costs

clicks

and then in the table put the following conditions for the columns:

clikcs: $(VshowCOST)='clicks'

cost: $(VshowCOST)='cost'

Please let me know if I misunderstood you

Re: hidding columns

Anonymous — Tue, 21 Feb 2012 13:51:53 GMT

Hope the following attached file will be helpful for your requirement

Regards

Ashok

hidding columns

Tue, 21 Feb 2012 14:33:32 GMT

i succeded to do it with button,

i set variable "VshowCost" = 0

and in chart properties i give condition:

=GetSelectedCount($Field)=vShowCost

in the button i set variable : VshowCost

value: 1

and now it work but i still cant do it in the list box.

thank you all for the help

eran