Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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