topic Re: RE:Only one sheet in Visualization and Usability

RE:Only one sheet

Chanty4u — Sat, 17 Feb 2018 06:12:09 GMT

Hi All,

omarbensalem‌youssef.belloum‌

ogster1974‌

i have a requirement like below.

i have 4 sheets in Qliksense

SheetA SheetB SheetC SheetD

and i have a filed with Department values like A,B,C,D

so my requirement is: i want to implement SectionAccess for Department A

here all that sheets should reflect the section access except SheetA .

Example: SheetA - count(Region) =10

SheetB - Count(Region)=10

but i apply section access for Departmnet A

SheetA count should be 10 only

SheetB count should be 4 or 5 like all sheet

how to implement this?

Re: RE:Only one sheet

ogster1974 — Sat, 17 Feb 2018 16:07:00 GMT

Section access is about the reduction of data in your data model.

Your requirement is taking more about presenting all data on one sheet then a filtered view on the others probably using set analysis.

I think you are best looking at modifying your data model to have a summary table for sheet a and then a more traditional data model you can reduce using section access for the other sheets.

Re: RE:Only one sheet

Chanty4u — Sun, 18 Feb 2018 12:36:49 GMT

thanks andy on your inputs , can we achieve this? devarasu07‌

do you have any inputs on this? lironbaram Kaushik Solanki

Re: RE:Only one sheet

passionate — Sun, 18 Feb 2018 16:12:04 GMT

You can achieve this via generic keys:

Section Access - a common business scenario

Re: RE:Only one sheet

Chanty4u — Sun, 18 Feb 2018 17:06:42 GMT

thanks for the link . but i need this in Qliksense..

is this works?

Re: RE:Only one sheet

passionate — Sun, 18 Feb 2018 17:09:29 GMT

I don't see any reason that it won't work in qliksense

Re: RE:Only one sheet

Chanty4u — Sun, 18 Feb 2018 17:16:37 GMT

any alternate?

Re: RE:Only one sheet

kaushiknsolanki — Mon, 19 Feb 2018 06:11:11 GMT

Hi,

Can you share some sample data and also expected output.

Regards,

Kaushik Solanki