topic Re: To match the KPI value with qlik table in App Development

To match the KPI value with qlik table

Aspiring_Developer — Wed, 07 Apr 2021 08:59:09 GMT

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 — Wed, 07 Apr 2021 09:56:04 GMT

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

Aspiring_Developer — Wed, 07 Apr 2021 11:49:27 GMT

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 — Thu, 08 Apr 2021 16:37:22 GMT

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.