topic Column control in App Development

Column control

Mahamed_Qlik — Tue, 31 Aug 2021 05:20:00 GMT

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.

Re: Column control

saniyask — Tue, 31 Aug 2021 09:16:00 GMT

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/manage-security-with-section-access.htm

Saniya.

Re: Column control

Mahamed_Qlik — Tue, 31 Aug 2021 09:55:36 GMT

Thank you Saniya for you repsonse.

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

Re: Column control

NitinK7 — Wed, 01 Sep 2021 10:15:08 GMT

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)

Re: Column control

Mahamed_Qlik — Wed, 01 Sep 2021 18:15:00 GMT

Thanks Nitin for reply.

My requirement is with Qlikview not in Qliksense 🙂