Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Issue : Cumulative Graph

Hi All,

I make a report that shows 4 analysis on the basis of Days :-

i) Current Month Data(Cumulative) - Jan,2013 - Line Graph

ii) Previous Month Data(Cumulative)- Dec, 2012 - Line Graph

iii) Previous Year Month Data(Cumulative) - Jan,2012 - Line Graph

iv) Current Month - Jan 2013 - Bar Chart

But in that report I have data till 9th of Jan, 2013 and I want Current Month Data(Cumulative) line graph will stop on 9th(Show in Blue Line) either the line extends till end of the month by showing similar figure that is on 9th jan throughout the month.

For reference please go to the attached image.

Thanks & Regards

Suresh Rawat

1 Reply
Specialist
Specialist

You can set the colour of the line under the [+] symbol next to the expression. If this date is less than or eqaul today blue, if greater than today then white. Problem with that is that if a line intersects the flat line later in the month it gets a break in it.

You can also add an if test around your expression, something like:

if(TransDate>Today(),0,

sum({<TransDate={'>=$(MTDStart) <=$(MTDEnd)'}>} Sales)

)

This will drop the line down to zero. You can then go to the presentation properties and tick the Suppress zero values setting. Be careful however as this will exclude dates from the x axis if there is not data for them.

Jonathan