Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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
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