Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create object independent of other selections on sheet

Hi There... Does anyone know how to create an object that is independent of the selection on the same sheet.

Example. I want to create a chart that displays all accounts that was opened in the selected year and show how their status changed over the years to follow.  The data is on transaction level . Other charts on the sheet will show the count of accounts that was opened in the selected year ='Count({<[NEW ACC] = {"Y"}>} DISTINCT [ACC NUMBER])' .

The new chart will be a pipeline that links on the account number and displays a count per status per year to follow.

Hope this makes sense.

4 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     You can exclude the selection by using set analysis by using the "fieldname=" inside the set analysis part like below.

      =Count({<[NEW ACC] = {"Y"},Year=,Month=>} DISTINCT [ACC NUMBER])

In the above expression year and month selection will be excluded. You can use the fields that you want to exclude in that way.

Hope it helps

Celambarasan

Not applicable
Author

Hi there

 

Thank you for the fast response.

 

One more problem with this... because the data is on transaction level, this does not work.

 

Example of data:

Year Account No New Account Status Current Transaction

2009 123       Y Open

2010 123 Open

2011 123 Open

2012 123 Closed       Y

 

Chart 1 On the selection of 2009 it will count this as a new account.    

=Count({<[ New Account ] = {"Y"}>} DISTINCT )

Char 2 Needs to show what is the current status of the accounts selected under new accounts for 2009.

=Count({<[Current Transaction] = {"Y"},Year=>} DISTINCT ) - by doing this it counts all the transactions with Current status = Y and not only the accounts that had a New Account indicator in 2009.

 

I need a way to hold the account numbers selected by the main selections.

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try with this expression

     =Count({<[NEW ACC] = {"Y"},Year={'$(=Max(Year))'}>} DISTINCT [ACC NUMBER])

     Or

      =Count({<[NEW ACC] = {"Y"},Year={"$(=Chr(39)&Concat(Year,Chr(39)&',''&Chr(39))&chr(39))"}>} DISTINCT [ACC NUMBER])

Hope this is your need

Celambarasan

ekech_infomotio
Partner - Creator II
Partner - Creator II

If you are working with QV11 you could try to implement it via "alternate states" - just start with looking at the "whats new in Qlikview11"-example (Tabs "Product Grouping" and "Sales Overlap") to get an idea how alternate states work.

Hope this helps,

Edgar