Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
tulasiram_bitra
New Contributor III

How to consider latest day sales for zero sales of that date in bar chart

Hello Guys,

I have taken Date as dimension and sum(Application_sales) as Measure. I need to consider last day sales if i dnt have sales on that day.

For example,

Date,                     Sales

01-04-2018 , 200

02-04-2018, 400

03-04-2018, 0

04-04-2018,0

05-04-2018, 600

Here, I need to show sales of 02-04-2018 ( 400 ) to 03-04-2018 and 04-04-2018 also. please find the attached image.

Please help me in this.

Thanks.. Tulasiram

1 Solution

Accepted Solutions
MVP
MVP

Re: How to consider latest day sales for zero sales of that date in bar chart

For front-end solution, try like:

Capture.JPG

Capture2.JPG

View solution in original post

3 Replies
MVP
MVP

Re: How to consider latest day sales for zero sales of that date in bar chart

You can try loading like:

Load Date,

            If(Sales=0, Peek(Sales), Sales) as Sales

MVP
MVP

Re: How to consider latest day sales for zero sales of that date in bar chart

For front-end solution, try like:

Capture.JPG

Capture2.JPG

View solution in original post

tulasiram_bitra
New Contributor III

Re: How to consider latest day sales for zero sales of that date in bar chart

Hello Tresesco,

It is working fine. Thank you so much.