topic Re: Date selections shows data issues in QlikView

Date selections shows data issues

cbaqir — Tue, 25 Feb 2020 16:15:41 GMT

If there are no selections, my line graph (Expression count(Distinct FIRING_RECORD) looks good:

However, if I filter down to 2019, it looks like there are some significant data gaps. I've been going around in circles and can't figure out what is going on. Any ideas?

Re: Date selections shows data issues

nisha_rai — Wed, 26 Feb 2020 08:03:31 GMT

Hi,

Can you share the expression.

Re: Date selections shows data issues

cbaqir — Wed, 26 Feb 2020 14:03:15 GMT

It's listed above: (Expression count(Distinct FIRING_RECORD)

Re: Date selections shows data issues

Brett_Bleess — Tue, 31 Mar 2020 15:26:05 GMT

I would expect either a data model related issue or something related to AGGR being needed as the two most likely culprits, so unless you can attach a sample QVW with the issue, not sure anyone is going to be able to offer much further help. The best I could do is point you to the Design Blog area to dig around there to see if you can find some posts that will help you sort out what is missing.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

If you did get things resolved, please be sure to close out the thread by posting what the issue was and then use the Accept as Solution button on that post to close out the thread.

Regards,
Brett