topic Date loop in chart in QlikView

Date loop in chart

Sat, 29 Oct 2016 13:50:14 GMT

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

Re: Date loop in chart

swuehl — Sun, 30 Oct 2016 12:38:35 GMT

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.

The Master Calendar

Re: Date loop in chart

Mon, 31 Oct 2016 10:23:44 GMT

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

Re: Date loop in chart

swuehl — Mon, 31 Oct 2016 17:07:50 GMT

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?

Re: Date loop in chart

Tue, 01 Nov 2016 05:54:24 GMT

Hi Dear Stephan

unfortunately I don't have a use advanced editor to attach qvw file in here

Re: Date loop in chart

swuehl — Tue, 01 Nov 2016 16:56:16 GMT

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

Date loop in chart

Re: Date loop in chart

Wed, 02 Nov 2016 06:19:22 GMT

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 ?