Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
lampshadedreams
New Contributor II

‘Common’ selections available to all states

Hi, 

I have a dashboard with two sheets. 

Sheet A:

  1. User Filter
  2. Year Filter
  3. Month Filter
  4. Funds Filter
  5. Funds Chart -> Sum(Funds)

Sheet B:

  1. User Filter
  2. Year Filter
  3. Month Filter
  4. Spent Filter
  5. Spending Chart -> Sum(Spending)

The Red items are common filters whereby if a selection is made in one sheet the same selection should be made in the other sheet.

However the Blue and Green filters are to only select data in their respective sheets. (i.e if Funds Filter is selected the spending chart in the next sheet should not be impacted)

I tried setting up Alternate States for each sheet but then the common Red filters are not available across the sheets.

Any idea?>

 

 

1 Solution

Accepted Solutions

Re: ‘Common’ selections available to all states

Assuming your state name on Sheet A is AS1.. you can try this

Sum({AS1<User = $::User, Year = $::Year, Month = $::Month>}Funds)
3 Replies

Re: ‘Common’ selections available to all states

Assuming your state name on Sheet A is AS1.. you can try this

Sum({AS1<User = $::User, Year = $::Year, Month = $::Month>}Funds)
lampshadedreams
New Contributor II

Re: ‘Common’ selections available to all states

I think that worked!

I created a straight table to verify the data on Sheet A:

UserYearMonthFunds
    

 

However, I am not sure how I would apply the same to straight table. Do I apply set analysis to each expression in the straight table (each column) or to just the dimension?

Re: ‘Common’ selections available to all states

Each expression where you want the selection to driven from AS1 except for Month, Year, & User which are driven by default state