Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

‘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
Highlighted

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)

View solution in original post

3 Replies
Highlighted

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)

View solution in original post

Highlighted
Contributor III
Contributor III

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?

Highlighted

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