Line chart data

[#1]

Hi All,

Please help me on this.

I have added Line Chart which shows year wise sales. I tick the display "values on data point" which shows values all over. My requirement is that I want to display only Max and Min values on data point. Not all values.

Thanks in Advance

[vinieme12]

Keep Values on Data Points Checked

Expand the Expression

See "Show Value"

          define expression as

               if(Year = Max(TOTAL Year) or Year = MIN(TOTAL Year) , Expression)

[vinieme12]

[#4]

Sorry Vineet.

I have trend of monthly actually.

Months are in number & sum field is Data.

Please help

[vinieme12]

use the same with Month then

   if(Month= Max(TOTAL Month) or Month= MIN(TOTAL Month) , 1)

[vinieme12]

if your problem has been resolved, please close the thread by marking a response as correct

Qlik Community Tip: Marking Replies as Correct or Helpful

[MarcoWedel]

maybe helpful:

Trellis chart: How to generate variable y-axes

regards

Marco

[#8]

Hi Vineeth,

Sorry but still its not working. I have attached the my requirements below. I have created this chart in excel. I want to create same in QlikView. You can see Max & Min values on trendline.

[vinieme12]

Have a look at marcowedel reponse on the thread he has kindly posted, it is exactly what you need,

[#10]

hi Vineeth,

I have been looking in it but most of the examples belongs to scripting. I have not reached to scripting yet. would you suggest where I can find that solution?