Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator II
Creator II

To match the KPI value with qlik table

Hello Everyone,

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

Aspiring_Developer_0-1617785606694.png

 

I have to create a KPI with this measure :-

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

Aspiring_Developer_1-1617785790858.png

 

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 ??

 

3 Replies
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.

MayilVahanan_0-1617789337276.png

 

Thanks & Regards,
Mayil Vahanan R
Aspiring_Developer
Creator II
Creator II
Author

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
Employee
Employee

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.