topic Re: Line chart data in QlikView

Line chart data

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Line chart data

vinieme12 — Fri, 10 Feb 2017 13:21:36 GMT

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)

Re: Line chart data

vinieme12 — Fri, 10 Feb 2017 13:28:09 GMT

Re: Line chart data

Fri, 10 Feb 2017 13:33:46 GMT

Sorry Vineet.

I have trend of monthly actually.

Months are in number & sum field is Data.

Please help

Re: Line chart data

vinieme12 — Fri, 10 Feb 2017 13:35:18 GMT

use the same with Month then

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

Re: Line chart data

vinieme12 — Fri, 10 Feb 2017 14:10:11 GMT

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

Re: Line chart data

MarcoWedel — Sun, 12 Feb 2017 01:21:04 GMT

maybe helpful:

Trellis chart: How to generate variable y-axes

regards

Marco

Re: Line chart data

Mon, 13 Feb 2017 10:05:17 GMT

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.

Re: Line chart data

vinieme12 — Mon, 13 Feb 2017 10:11:11 GMT

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

Re: Line chart data

Mon, 13 Feb 2017 10:26:00 GMT

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?

Re: Line chart data

vinieme12 — Mon, 13 Feb 2017 10:27:02 GMT

can you post a sample to demonstrate?

Re: Line chart data

Mon, 13 Feb 2017 10:32:00 GMT

hi, here 499 is highest and 153 is lowest.

Re: Line chart data

vinieme12 — Mon, 13 Feb 2017 10:41:05 GMT

Can you post a sample app with dummy data? Can't demonstrate with an Image!

Preparing examples for Upload - Reduction and Data Scrambling

Re: Line chart data

Tue, 14 Feb 2017 07:43:44 GMT

Product	Sale
Year 1	2928
Year 2	1620
Year 3	2325
Year 4	4985
Year 5	4199
Year 6	4607

Here it is data table year wise and chart. In table you can see the total sale as per year where Year 2 has lowest sale and Year 4 has highest sale. So chart showing only highest and lowest values.

Please suggest on this.

Re: Line chart data

vinieme12 — Tue, 14 Feb 2017 07:54:18 GMT

See attached App

Re: Line chart data

Tue, 14 Feb 2017 07:55:21 GMT

Yes, this is what I want. How to do this? please guide me.

Re: Line chart data

ganeshreddy — Tue, 14 Feb 2017 08:31:19 GMT

Hi Surya,

This is how vinieme12 did it

highlighted expression in black:

=if([Sales] = Max(TOTAL Aggr(sum(Sale),Product)) or [Sales] = Min(TOTAL Aggr(sum(Sale),Product)) ,1,0)

Thanks,

Ganesh

Re: Line chart data

vinieme12 — Tue, 14 Feb 2017 09:12:25 GMT

Thanks for pointing that out to the OP