Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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)