topic Re: Bar Chart Reference Line Label in QlikView

Bar Chart Reference Line Label

selcukcadir — Thu, 13 Nov 2014 10:19:17 GMT

Hi all,

How can we solve the problem in the attached document?

Thanks...

Re: Bar Chart Reference Line Label

vinay_hg — Thu, 13 Nov 2014 10:24:05 GMT

what is the problem. can you pls brief.

Re: Bar Chart Reference Line Label

vardhancse — Thu, 13 Nov 2014 10:25:18 GMT

in chart properties->presentation->Reference line. based on condition the reference line will be shown in bar chart

Re: Bar Chart Reference Line Label

selcukcadir — Thu, 13 Nov 2014 11:17:42 GMT

Max value : 2 and should be max Month = Oca

Re: Bar Chart Reference Line Label

vardhancse — Thu, 13 Nov 2014 11:21:18 GMT

Try to enable the option

Re: Bar Chart Reference Line Label

selcukcadir — Thu, 13 Nov 2014 11:27:06 GMT

Label enable ok.

I do not calculate the date (max Month) information

Re: Bar Chart Reference Line Label

selcukcadir — Thu, 13 Nov 2014 13:10:07 GMT

Re: Bar Chart Reference Line Label

Thu, 13 Nov 2014 13:34:07 GMT

Hi, Could you try this?

Max(Aggr(sum(value1) / sum(value2),MonthDate )) & ' Max Month : ' & FirstSortedValue(MonthDate, -(value1/value2))

Regards

Re: Bar Chart Reference Line Label

MarcoWedel — Thu, 13 Nov 2014 15:19:31 GMT

='Max Value : ' & Max(Aggr(sum(value1) / sum(value2),MonthDate )) & ' Max Month : ' & FirstSortedValue(MonthDate, -Aggr(sum(value1) / sum(value2),MonthDate ))

hope this helps

regards

Marco

Re: Bar Chart Reference Line Label

MarcoWedel — Thu, 13 Nov 2014 16:01:23 GMT

FirstSortedValue(MonthDate, -(value1/value2))

matches your requirements, then there is only one value1/value2 combination per month in your data, which means that you could also abbreviate your other expressions like:

=Max(value1/value2)

for the reference line and

='Max Value : ' & Max(value1/value2) & ' Max Month : ' & FirstSortedValue(MonthDate, -(value1/value2))

for the text in chart.

hope this helps

regards

Marco