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: 
Not applicable

Graph only part of a dataset

Dear all,

I am working on the attached Qlikview file. However there seems to be a small bug in the file. The only thing that see is the view attachment (even if I make sure nothing is selected!).

This seems kind of odd as I should see more salesdates... Any thoughts on what goes wrong here?

Cheers,

Marc !

1 Reply
sunny_talwar

2 issues

1) Your numbers were not read as number and were instead read as text (except 12)

Temp Fix:

SET ThousandSep=',';

SET DecimalSep='.';

2) Your expression was wrong, try this:

Sum({$<SalesDate={">=$(=Date(vFromDate, 'YYYY-MM-DD'))<=$(=Date(vToDate, 'YYYY-MM-DD'))"}>} Value)