topic Re: pivot table,action to change column data in QlikView

pivot table,action to change column data

everest226 — Wed, 25 Nov 2020 16:16:04 GMT

hi i have a pivot table in which in one column i have employee name, my requirement is that i have to create a bottom or text object thats says hide name so when i click hide name the all employee name inside my pivot table must be --------------- dash dash.

julien.frechet‌

Amy Goldberg will be --------------

Re: pivot table,action to change column data

sunny_talwar — Wed, 11 May 2016 18:00:21 GMT

May be create a variable and use an expression like this:

If(vVar = 1, [employee name], '-------------')

and assign button action to toggle the variable vVar between 1 and 0.

Re: pivot table,action to change column data

msdeepak — Wed, 11 May 2016 18:07:36 GMT

Sunny's solution is spot on. Refer this Replace value in dimension of straight table with *** for code example.

Re: pivot table,action to change column data

everest226 — Wed, 11 May 2016 18:27:07 GMT

thanks,

Re: pivot table,action to change column data

everest226 — Wed, 18 May 2016 00:12:21 GMT

Thanks Sunny

Re: pivot table,action to change column data

sunny_talwar — Wed, 18 May 2016 01:00:42 GMT

You already thanked me once before, again?