topic Re: Section access to switch between fields in QlikView

Section access to switch between fields

sifatnabil — Fri, 30 Sep 2016 11:33:46 GMT

Hi all,

I have a set of users who should only be able to see volumes. Another set should be able to see revenues and volumes. My data table is like this:

Date, Revenue, Volume, Product

1/1/2015, $1000, $500, A

1/1/2015, $1050, $400, B

Is there a way to create 1 chart where, depending on the user, it will display revenue or volume?

I am thinking of using OSuser() but not sure of the most sustainable way to do this. Thanks.

Re: Section access to switch between fields

awhitfield — Fri, 30 Sep 2016 11:35:31 GMT

why not have 2 charts with a conditional show based on a variable set by a button?

Andy

Re: Section access to switch between fields

sifatnabil — Fri, 30 Sep 2016 11:38:58 GMT

Thanks awhitfield‌, I was thinking that this means doubling up on all the charts, i.e. 2 of everything. Would it be possible to have just one version of all charts but display 2 different fields depending on the user? I'm guessing in expression I have to do something like if(match(OSUser(),'Bob'),FieldA) but this seems tedious.

Re: Section access to switch between fields

giakoum — Fri, 30 Sep 2016 11:41:32 GMT

if you hide the Revenue from some users using section access, it will show nothing on the chart.

So you could have one chart with 2 expression : sum(Revenue) and sun(Volume) and for some users the 1st one will just show nothing.

Re: Section access to switch between fields

sifatnabil — Fri, 30 Sep 2016 12:15:05 GMT

This actually works - the legend of the hidden field still stays though. Is there a way to remove that?

Re: Section access to switch between fields

prat1507 — Fri, 30 Sep 2016 12:22:12 GMT

Hi Sifat

PFA the .qvw for your reference. Here I've used a variable to get the username using OSUser(), then for my user I've assigned BIT_REV =1(if you want to show revenue, or 0 if you don't)

BIT_VOL =1(if you want to show volume, or 0 if you don't)

in an inline table.

Then using the condition if(only({<USERNAME={'$(=OSUser())'}>}BIT_REV)=1,1,0) in the Presentation tab to show the column Revenue and if(only({<USERNAME={'$(=OSUser())'}>}BIT_VOL)=1,1,0) in the Presentation tab to show the column Volume, I got the desired result.

Regards

Pratyush

Re: Section access to switch between fields

giakoum — Fri, 30 Sep 2016 12:27:29 GMT

is suppress when null checked?

Re: Section access to switch between fields

sifatnabil — Fri, 30 Sep 2016 12:52:36 GMT

Yes - that still keeps the legend on.