Column control

[Mahamed_Qlik]

Hello experts,

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)

Product	Sales 1	Sales 2	Sales
Furniture	2000	3000	4000

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)

Regards,

Mahamed.

[saniyask]

Hi,

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.

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/man... 

Saniya.

[Mahamed_Qlik]

Thank you Saniya for you repsonse.

But, in my case the columns are measures not dimensions so not able to achieve this

[NitinK7]

Hi,

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)

[Mahamed_Qlik]

Thanks Nitin for reply.

My requirement is with Qlikview not in Qliksense 🙂