Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help - Specific line chart needed

Hi All,

I have a line chart dimensioned by

     - Time (Dates formated like 'MMM - YYYY'),

     - and a calculated dimension (3 categories based on price evolution)

          =If(aggr(avg(Price_Evolution), Part_Code)> dblPriceEvolBorne_Up, 'UP',

          If(aggr(avg(Price_Evolution), Part_Code)< dblPriceEvolBorne_Down, 'DOWN', 'STABLE'))

I want to compute a Quantity Index based on a spedific date.

So the chart will display 3 curves (related to the calculated dimension). Each curve will be equal to 100 at the specific date.

The expression I tried is the following :

          =   Sum(Gross_Quantities) /

          Sum({$ <Year_Months={'$(=Min(Implementation_Dates))'}>}

          Gross_Quantities)

The issue is that this limit the dimension of the chart to the date specify (only the Min(Implementation_Dates) appears with 3 points).

Please could you help me on this?

Many thanks in advance

2 Replies
Not applicable
Author

Hi all,

I have no comment on the issue I faced. I post righ now some more elements that could help you  understand the issue and what I expect.

You will find join to this message a picture  of the chart I expect (made in Excel).

Also there is an qvw file with a sample data that could helpp you understand the issue I face.

Expected_Chart.png

Thanks in advance for your help

Not applicable
Author

Please I need help on it. Is there somebody who could help ?