Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

Calculation Help

Hi Experts,

stalwar1

youssefbelloum

omarbensalem

jyothish8807

Could you please help me on below requirement.

In the below Table I have Taken

Dimension as [Internal ID]

Measure as

if(

ISNULL(AGGR(

if(Match([Sales Product],'TV'),[Performance External ID],

if(Match([Sales Product],'Mobiles'),[Performance ID])),

[Internal ID])),count([Internal ID])


1. When I have used above dimension and measure in first table with Total as Auto and By checking Data Handling getting total measure count  as 4807.


2. In the second table I have changed Total as Sum and uncheck the Data handling so all null ids were removed and getting total measure count as 2966.


The requirement is I have to show 2966 count in KPI. How to change the above expression for getting 2966 count with above table settings.

Please help me on this.

 

1 Reply

Re: Calculation Help

Try this

Sum(Aggr(

If(

ISNULL(AGGR(

if(Match([Sales Product],'TV'),[Performance External ID],

if(Match([Sales Product],'Mobiles'),[Performance ID])),

[Internal ID])),count([Internal ID]),

[Internal ID]))

Community Browser