Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
Champion III
Champion III

RE:Only one sheet

Hi All,

omarbensalemyoussef.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?

7 Replies
ogster1974
Master II
Master II

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
Champion III
Champion III
Author

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

do you have any inputs on this? lironbaram    Kaushik Solanki

passionate
Specialist
Specialist

You can achieve this via generic keys:

Section Access - a common business scenario

Chanty4u
Champion III
Champion III
Author

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

is this works?

passionate
Specialist
Specialist

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

Chanty4u
Champion III
Champion III
Author

any alternate?

kaushiknsolanki
Luminary Alumni
Luminary Alumni

Hi,

Can you share some sample data and also expected output.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".