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: 
selcukcadir
Creator II
Creator II

Bar Chart Reference Line Label

Hi all,

How can we solve the problem in the attached document?


Thanks...

1 Solution

Accepted Solutions
Not applicable

Hi,  Could you try this?

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

Regards


View solution in original post

9 Replies
vinay_hg
Creator III
Creator III

what is the problem. can you pls brief.

vardhancse
Specialist III
Specialist III

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

selcukcadir
Creator II
Creator II
Author

     Max value : 2  and should be max Month = Oca

exp2.png

vardhancse
Specialist III
Specialist III

Try to enable the option label.JPG.jpg

selcukcadir
Creator II
Creator II
Author

Label enable ok.

I do not calculate the date (max Month) information

selcukcadir
Creator II
Creator II
Author

exp2.png

Not applicable

Hi,  Could you try this?

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

Regards


MarcoWedel

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

QlikCommunity_Thread_141981_Pic1.JPG.jpg

QlikCommunity_Thread_141981_Pic2.JPG.jpg

hope this helps

regards

Marco

MarcoWedel

If

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