Need help on conditional column hide in pivot with user specific.
I have below pivot table with dimension " Product" and measures ( Sales 1, Sales 2, Sales 3)
I have 3 users User 1, User 2, User 3.Requirnment is -
User 1 should see all the measures columns ( Sales 1, Sales 2, Sales 3) in pivot table along with dimension.
User 2 should see only (Sales 1, Sales 2)
User 3 should see only (Sales 1)
You can achieve this by adding Section access to your application, Fields can either be omitted completely or can be Reduced for certain users as per you requirement.
Thank you Saniya for you repsonse.
But, in my case the columns are measures not dimensions so not able to achieve this
you can do using show column if property in qliksense pivot table.
you need to write exp based on username/OSUSER
in my case I wrote-
if(mixmatch(Subfield(subfield(OSUser(),';',2),'=',2),'ABC-PQR'),1,0)-------------(ABC-PQR is user osuser name)
Thanks Nitin for reply.
My requirement is with Qlikview not in Qliksense 🙂