topic Re: Dimension as legend for multi expression in QlikView

Dimension as legend for multi expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I need to show the dimensions as my legend values. It is working when i am having only one expression but with more than one, the expression value is coming as legend rather than dimension values.

Sample is attached. Any help would be appreciated.

Thanks.

Re: Dimension as legend for multi expression

vamsee — Fri, 09 Mar 2018 18:33:44 GMT

Hello,

Try this.

Re: Dimension as legend for multi expression

Anonymous — Sat, 10 Mar 2018 03:51:34 GMT

Thanks Vamsee, but the given idea is not working. It is still showing the expression value in the legends.

Re: Dimension as legend for multi expression

ravikumar_iyana — Sat, 10 Mar 2018 10:05:17 GMT

Hi Suresh,

u can click on chartproperties---> Expressions ---> click on Expression as Legend

Re: Dimension as legend for multi expression

el_aprendiz111 — Sat, 10 Mar 2018 17:57:39 GMT

Hi,

Re: Dimension as legend for multi expression

Anonymous — Tue, 13 Mar 2018 09:05:56 GMT

I need to show dimension as my legend. I am not understanding what you are saying.

Re: Dimension as legend for multi expression

Anonymous — Tue, 13 Mar 2018 09:06:28 GMT

I need to show dimension as my legend and not expression.

Re: Dimension as legend for multi expression

binujose1982 — Wed, 14 Mar 2018 00:13:45 GMT

Hi Suresh,

One solution for your requirement is to create cyclic expression group.

Expression tab-> Select both expression -> click on group.

In the chart: Use the expression cycle in the bottom left to change between both expression.

I have attached the sample file.Hope this will help you.

Regards,

Binu

Re: Dimension as legend for multi expression

Nagaraju_KCS — Wed, 14 Mar 2018 03:08:14 GMT

I think your scenario it won't work.

1. If you have one expression, second dimension shows as legend.

2. One dimension, you have to take 2 expressions with different attributes, if you have different measures it won't work.

One dimension as Date and 2 expressions

Sum({<Name={'Name1'}>}Requested) label as Name1

Sum({<Name={'Name2'}>}Requested) label as Name2. these shows as legend (Name1 and Name2)

otherwise create Cyclic Group, based on Date and Name dimensions.

This can be possible in Scatter Chart.

Have added one more date.

LegendTest:

Load * Inline [

Date, Name, Requested, Approved

2018-01-01, Name1, 250, 150

2018-02-02, Name1, 450, 350

2018-02-02, Name2, 150, 250

2018-01-01, Name2, 50, 100 // New added

];

But this works Total based. (X and Y axis)

topic Re: Dimension as legend for multi expression in QlikView

Dimension as legend for multi expression

Re: Dimension as legend for multi expression

Re: Dimension as legend for multi expression

Re: Dimension as legend for multi expression

Re: Dimension as legend for multi expression

Re: Dimension as legend for multi expression

Re: Dimension as legend for multi expression

Re: Dimension as legend for multi expression

Re: Dimension as legend for multi expression

Thanks..