Showing a constant value for a measure in all rows

[rajarshi_guin]

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

[maxgro]

Count(Distinct TOTAL [Firms Targetted])

[jagan]

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.