topic Re: How to change the Legend presentation in QlikView

How to change the Legend presentation

Mon, 04 Jan 2016 05:44:34 GMT

Hi all,

Anybody could help how to present the legend like Qlik Sense in Qlikview?

Qlik Sense:

Qlikview:

Best Regards,

Alan

Re: How to change the Legend presentation

abirami_palanis — Mon, 04 Jan 2016 13:16:32 GMT

Hi,

you can present the legend in Qlikview like in Qliksense.

write your expression.

Add one more expression like what you want to display in legend.

Check in value on data points.

You can get legend in chart like below

Re: How to change the Legend presentation

settu_periasamy — Mon, 04 Jan 2016 13:34:50 GMT

You can try something like the expression

=Dual(LegendField,Count(Measure))

Check the Attachment

Re: How to change the Legend presentation

effinty2112 — Mon, 04 Jan 2016 13:55:02 GMT

Hi,

Settu's response is very good but I suggest you try a small variation of it as well as Settu's suggestion:

=Dual(

LegendField

Repeat(chr(13)&chr(10), rank(Count(Measure))-4)

,Count(Measure))

This technique is one I learnt from Stephen Redmond's useful book Qlikview for Developers Cookbook. The repeat function adds carriage returns to your 5th and 6th label and this staggering should make them easier to read.

Re: How to change the Legend presentation

Tue, 05 Jan 2016 01:44:38 GMT

Thanks to Abirami Palanisamy / settu_periasamy / Andrew Walker.

All your methods work. I can't see any difference between these 3 methods. To me, a rookie of qlikview, Abirami and settu's method is easier to use and understand.