Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

suresh_vasu3
New Contributor

Dimension as legend for multi expression

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.

8 Replies
vamsee
Valued Contributor

Re: Dimension as legend for multi expression

Hello,

Try this.

294284.JPG

suresh_vasu3
New Contributor

Re: Dimension as legend for multi expression

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

ravikumar_iyana
Contributor

Re: Dimension as legend for multi expression

Hi Suresh,

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

el_aprendiz111
Valued Contributor

Re: Dimension as legend for multi expression

Hi,

linInvis.gif

suresh_vasu3
New Contributor

Re: Dimension as legend for multi expression

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

suresh_vasu3
New Contributor

Re: Dimension as legend for multi expression

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

binujose1982
New Contributor III

Re: Dimension as legend for multi expression

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

qv_testing
Valued Contributor

Re: Dimension as legend for multi expression

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)

OR

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


OR


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)

Ab.JPG


Thanks..

Community Browser