topic Re: to create a graph that remains unaffected by the other queries. in Reporting Service & Alerting

to create a graph that remains unaffected by the other queries.

004931 — Fri, 15 Nov 2024 21:31:19 GMT

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.

Re: to create a graph that remains unaffected by the other queries.

Oleg_Troyansky — Sat, 24 Jun 2023 13:20:27 GMT

Hi there,

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!