Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

pivot table,action to change column data

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      --------------

1 Solution

Accepted Solutions
sunny_talwar

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.

View solution in original post

5 Replies
sunny_talwar

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.

msdeepak
Contributor II
Contributor II

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

everest226
Creator III
Creator III
Author

thanks,

everest226
Creator III
Creator III
Author

Thanks Sunny

sunny_talwar

You already thanked me once before, again?