topic Re: Max and Min Values on Data points in QlikView

Max and Min Values on Data points

Mon, 30 Nov 2015 08:56:25 GMT

Hi All,

I have a querry.i am using a line chart with product and the below expression for month as dimension

and i am using sum(volume) as expression.

=Dual(Aggr(NODISTINCT If(Week=Max(total <Month> Week), Month, ''), Month, Week), Week)

By using this expression the dimension label will be month were as the data points will be for weeks.as below graph.

here in the above graph,for each month you can see 4 or 5 data points ie. for each weeks.

Now i want to show values on data points only for the max week and the min week. Any idea how it can be achieved.

Regards,

Reena

Re: Max and Min Values on Data points

amit_saini — Mon, 30 Nov 2015 09:07:16 GMT

Hi,

See the attachment.

Thanks,

Re: Max and Min Values on Data points

amit_saini — Mon, 30 Nov 2015 09:08:29 GMT

you need to work here:

Thanks,

Re: Max and Min Values on Data points

jyothish8807 — Mon, 30 Nov 2015 09:09:58 GMT

Hi Reena,

try like this:

create two variable:

vMaxWeek=max(Aggr(NODISTINCT If(Week=Max(total <Month> Week), Month, ''), Month, Week))

vMinWeek=min(Aggr(NODISTINCT If(Week=Max(total <Month> Week), Month, ''), Month, Week)))

Now in chart, press + sign on expression.

go to show value:

=if(Week = '$(vMaxWeek)' or Week = '$(vMinWeek)' ,1,0)

Hope it helps.

Regards

Re: Max and Min Values on Data points

jagan — Mon, 30 Nov 2015 09:12:29 GMT

Hi,

Try like this

Expand + symbol of the expression and give this expression in Show Value option

=Dual(Aggr(NODISTINCT If(Week=Max(total <Month> Week) OR Week=Min(total <Month> Week) , Week), Month, Week), Week)

Re: Max and Min Values on Data points

Anonymous — Mon, 30 Nov 2015 09:16:29 GMT

Never noticed that Show Value option before, could be useful.

Re: Max and Min Values on Data points

jyothish8807 — Mon, 30 Nov 2015 09:18:12 GMT

Re: Max and Min Values on Data points

amit_saini — Mon, 30 Nov 2015 09:19:04 GMT

Re: Max and Min Values on Data points

tresB — Mon, 30 Nov 2015 09:36:47 GMT

Try expression (at Show Value property as shown above):

Aggr(NODISTINCT If(Week=Max(total <Month> Week), 1, 0), Month, Week) Or Aggr(NODISTINCT If(Week=Min(total <Month> Week), 1, 0), Month, Week)

Re: Max and Min Values on Data points

jyothish8807 — Mon, 30 Nov 2015 10:25:05 GMT

Hi Reena,

Try like this:

Create a new expression and disable line and symbol option and enable only value at data point.

If(WeekEndingDate_1=Max(total <ProductFranchise_13> WeekEndingDate_1),Sum([Volume TRx]), If(WeekEndingDate_1=min(total <ProductFranchise_13> WeekEndingDate_1), Sum([Volume TRx]),''))

Hope it works

Regards

Re: Max and Min Values on Data points

Mon, 30 Nov 2015 10:26:32 GMT

Thanks a lot Jyothish...it worked for me..