topic Re: Line Chart (Trend) over time until value changes in QlikView

Line Chart (Trend) over time until value changes

Tue, 21 May 2013 21:28:56 GMT

Hi all,

I have materials prices data, for eg,

Material	Date	Price per unit
A	1-jan-12	100
B	1-Jan-12	50
A	1-aug-12	110
B	1-jan-13	48

I want to show for Mat A trend line straight from Jan 12 to July 12 and then hike in Aug 12. SAme for matrail B. I am keeping date as dimension.

How to get it done? How to reload other months in the dimension when they are not there in the data and how to show same price as last month when it is not there in the data?

Re: Line Chart (Trend) over time until value changes

Gysbert_Wassenaar — Wed, 22 May 2013 13:36:10 GMT

You'll need to add the missing months. See here for how to do that. It is possible to use a continous axis for the Date field so intermediate missing dates are shown, but that won't help showing a line for A beyond 1-aug-12 because that's where the data ends for A.

Re: Line Chart (Trend) over time until value changes

Wed, 22 May 2013 13:54:06 GMT

Hi,

Try to load All months as Inline data and add that as a dimension and draw a line chart .

I hope it helps you

Re: Line Chart (Trend) over time until value changes

Wed, 22 May 2013 19:51:16 GMT

"but that won't help showing a line for A beyond 1-aug-12" may be Henric has answered your concern here (See last comment

"Yes, just change the definition of vMaxDate:

Let vMaxDate = Num(Today()) ;

HIC"

. I will try it at weekend.