Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Line chart with dates

I have a file with three fields: date, request received, request answered for a month with random dates.

For example:

Date                Request received Request answered

01/01/2014     125                              57

01/05/2014     154                              48

01/06/2014     187                              25

01/21/2014      124                             47

01/28/2014      165                             52



In the line chart i am using Date as dimension and looking at the data it is for the month of Jan. I want to display the line chart for all dates in Jan (31 days), from 1st of Jan to 31st of Jan.

Missing dates like 01/02/2014, 01/03/2014, 01/04/2014 upto 01/31/2014 i want to consider request received and request answered as 0.

I have created master calendar but that will not pick complete dates in Jan

Can someone help me what expression i have to write in dimension.

6 Replies

Re: Line chart with dates

Try with the properties in the line chart and select Date dimension and then un-check the option Suppress When Value Null  option but check if you are using Date field with Master calendar created.

Not applicable

Re: Line chart with dates

Suppress When value Null will help only when you have dates in dimensions and with a value of null or 0. In this case as I mentioned above we do not have all dates in jan in the file.


Something we have to do in dimension expression to pick-up all dates for the month (Jan) irrespective of where there is a record in the file then as you said we can uncheck the option Suppress When value Null

MVP
MVP

Re: Line chart with dates

see attachment for an example

Not applicable

Re: Line chart with dates

This example will not work as i have to create for all months.

I have created master calendar which displays all days of each month.

But the twist is, as soon as you select a product Date dimension will pick only the dates that are available in file.

For example

Product A:

Date                Request received Request answered

01/01/2014     125                              57

01/05/2014     154                              48

01/06/2014     187                              25

01/21/2014      124                             47

01/28/2014      165                             52


Date dimension will pick only above mentioned dates for Product A


Product B:


Date                Request received Request answered

01/01/2014     199                             57

01/02/2014     135                              48

01/03/2014     165                              25

01/20/2014      174                             47

01/30/2014      185                             52

morris70
Valued Contributor

Re: Re: Line chart with dates

Hi

This might help you.

Not applicable

Re: Line chart with dates

This example will not work as i have to create for all months.

I have created master calendar which displays all days of each month.

But the twist is, as soon as you select a product Date dimension will pick only the dates that are available in file.

For example

Product A:

Date                Request received Request answered

01/01/2014     125                              57

01/05/2014     154                              48

01/06/2014     187                              25

01/21/2014      124                             47

01/28/2014      165                             52


Date dimension will pick only above mentioned dates for Product A


Product B:


Date                Request received Request answered

01/01/2014     199                             57

01/02/2014     135                              48

01/03/2014     165                              25

01/20/2014      174                             47

01/30/2014      185                             52

Community Browser