To match the KPI value with qlik table

[Aspiring_Developer]

Hello Everyone,

I have a table in qliksense in which the number of records are 1439. Attached the excel extract of the table.

I have to create a KPI with this measure :-

count({$<PERIOD={"$(=Date(Max(PERIOD),'MMM YYYY'))"}>}AMOUNT_EUR)

It is giving me 1221 instead of 1439.

My requirement is it should show the same set of number of records in the KPI like we have in the table.

Can anyone please help ??

[MayilVahanan]

HI @Aspiring_Developer 

218 rows has null values in ur excel sheet. If you suppress null value in the chart, the values are tally.

[Aspiring_Developer]

Hi @MayilVahanan 

I want to show the values with null in the KPi object so that i can match it with the records in table.

Could you please suggest how can we achieve it ?

Thank You

[Dalton_Ruer]

Count a key field instead of the amount field that has nulls in it if you are simply looking for a count of the number of records.