Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a report in Qlik Sense as below
Market | Firms Tragetted | Measure 2 | Measure 3 |
---|---|---|---|
Market 1 | 100 | 1 | 1 |
Market 2 | 150 | 2 | 2 |
The Market column is a Dimension while others are measures. The Firms Tragetted value is calculated as-
Count(Distinct [Firms Targetted])
My concern is the Firms Targetted measure needs to be the distinct count from all the records in the database irrespective of the Market and the value will be constant for all the rows.
I tried few options like-
Count({1}Distinct [Firms Targetted])
Count({<[MARKET]=>}Distinct [Firms Targetted])
Count({<[MARKET]={}>}Distinct [Firms Targetted])
Count({<[MARKET]={''}>}Distinct [Firms Targetted])
But none of these are working. Can anyone please suggest how to do this.
Thanks,
Rajarshi
Count(Distinct TOTAL [Firms Targetted])
Hi,
If you want to ignore the dimensions in chart/table you have to use TOTAL in your set analysis like below
=Count(TOTAL Distinct [Firms Targetted])
Refer help file for more details about TOTAL.
Hope this helps you.
Regards,
Jagan.