Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
supriyabiware
Creator
Creator

Always include count corresponding to Null Dates in the chart when Some Date is selected

Hello,

I have requirement as below 

Account NoConsent Signed DateConsent Type
11.1.2020Opt In
21.2.2020Opt In
3--
4--
5--
61.3.2020Opt Out

 

Here 50% accounts have given consents and 50% have not

When user selects 2020 he should see all the above records including null dates in charts/KPIs! and not just 3 accounts 1,2,6.

I need null to be included in the expression of measure.

Any idea how?

GetExcludedCount, GetAlternateCount, etc i am not sure about usage of these.

Thanks & Regards,

Supriya.

 

 

Labels (3)
2 Replies
Anil_Babu_Samineni

If you have account no for null values they will visible by defauly, But check once "Data handling" in settings to be unchecked.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
supriyabiware
Creator
Creator
Author

Thanks for your reply. but i need the nulls counted even after date is selected. now when i select date the nulls are excluded from selection