Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sureshqv
Esteemed Contributor 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?

Tags (1)
7 Replies
ogster1974
Honored Contributor II

Re: RE:Only one sheet

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.

sureshqv
Esteemed Contributor III

Re: RE:Only one sheet

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

do you have any inputs on this? lironbaram    Kaushik Solanki

passionate
Valued Contributor

Re: RE:Only one sheet

You can achieve this via generic keys:

Section Access - a common business scenario

sureshqv
Esteemed Contributor III

Re: RE:Only one sheet

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

is this works?

passionate
Valued Contributor

Re: RE:Only one sheet

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

sureshqv
Esteemed Contributor III

Re: RE:Only one sheet

any alternate?

Re: RE:Only one sheet

Hi,

Can you share some sample data and also expected output.

Regards,

Kaushik Solanki

Community Browser