RE:Only one sheet

[Chanty4u]

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?

[ogster1974]

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.

[Chanty4u]

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

do you have any inputs on this? lironbaram    Kaushik Solanki

[passionate]

You can achieve this via generic keys:

Section Access - a common business scenario

[Chanty4u]

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

is this works?

[passionate]

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

[Chanty4u]

any alternate?

[kaushiknsolanki]

Hi,

Can you share some sample data and also expected output.

Regards,

Kaushik Solanki