Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends . Ive started qlikview learning just recently .
I have a question :
I have a sql data base which it has Sale Date column . want to have a Date Loop(writing with qlikview script) in my chart and compare each day with Sale Date(from sql database) .and if they were != then put SaleQTY =0 else read from SaleQTY of my table in Sql
first thing is Date Loop whatever I search It shows me one number not a range of date .
second comparing SQL data with qlikview data range is it possible at all?
Please help me on this
Negar
If I understand correctly, it might be enough to create a master calendar with all dates you want to look at in your script and link the master calendar to your sales date field.
Then use the master calendar field in your chart as dimension and use
=Sum(SalesQTY)
as expression. Disable 'suppress zero values' on presentation tab to see the dates with zero quantity.
Hi Stephan
thanx a lot it was really helpful but I have a another problem . the bar of the zero Sale QTY is different with the nonzero sale QTY .I want to show them all in a same bar in chart. even as a line
I attached the pic with this reply
Best Regards
Negar
It's not quite clear how your data model looks like and what you have used as dimensions and expression in your chart. Could it be that the dimension returns NULL (there is an option on dimension tab to suppress NULL)?
Could you post a small sample QVW and a description of what you want to achieve?
Hi Dear Stephan
unfortunately I don't have a use advanced editor to attach qvw file in here
To access the advanced editor (to be able to upload files), you need to open the thread not from within the inbox, but from the content page. Just follow the link to your thread
Hi Dear Stefan
Thanx a lot for your help . I added a master calendar too . but I think I have to put 0 instead of Null . how its possible ?