to create a graph that remains unaffected by the other queries.
Hello,
I'm currently dealing with banking data. I have two queries that I utilize to retrieve the count of cards sold and the corresponding turnover for those cards. When I work with these queries in the data manager, they automatically link together based on a common column. As a result, when I construct a dashboard on a sheet, they affect each other. I would like to know how to create a graph (kpi) that remains unaffected by the other queries.
The best way to detach a certain object or a certain measure from selections is to use Set Analysis {1} in the Measure, or in all measures for a given object. For example, if your formula is this:
Count(CardID)
then a new formula that's detached from all user selections, would look like this:
count({1} CardID)
For more information about advanced uses of Set Analysis and AGGR(), check out my session at the Masters Summit for Qlik - coming soon to Orlando and to Dublin!
