Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

markp201
Contributor III

Qlik Sense data model stats

I exported the table and there are only 3915 rows and I even have a record #.  I've checked and there are no duplicates.

Why does it show 3922 ?

Tags (1)
3 Replies
omarbensalem
Esteemed Contributor

Re: Qlik Sense data model stats

when you add a kpi object with count(AkeyDimension); what do u have ? 3915 or 3922?

markp201
Contributor III

Re: Qlik Sense data model stats

kpi shows 3922.  btw the stats above are for the inspector field as well as the kpi.

omarbensalem
Esteemed Contributor

Re: Qlik Sense data model stats

put a table:

as dimension: yourDim and color it by expression ; if(count(YourDim)>=2,red(),green())

as measure: count(YourDim)

this way, u can situate what's going on