topic Re: Legend in qlikview bar chart in QlikView

Legend in qlikview bar chart

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

Hello everyone,

I am facing issue in displaying 3rd dimension as legend in qlikview bar chart.

Example:

Resource = ABC

Project=A

Key

Key1=20
key2=50

Total =70

key1 %=20/70 =29%

Key2% =50/70= 71 %

I am using, Dimension1= "Resource" , Dimesnsion2= "key" to stack the data on key, and my expression is working as per my requirement.

Now, i have to display Project as a legend, for which i am facing issue.

I tried using "Project &key" together as key, but i have to display only distinct projects in the legend not with the key.

Please help me in resolving this issue.

Thanks,

Pooja

Re: Legend in qlikview bar chart

jonathandienst — Thu, 08 Feb 2018 06:19:29 GMT

>>Now, i have to display Project as a legend, for which i am facing issue.

I am not sure what you mean by this. You will not be able to add a 3rd dimension to the chart. I suggest that you build a mock-up to show what you require.

Re: Legend in qlikview bar chart

avinashelite — Thu, 08 Feb 2018 06:24:00 GMT

Pooja , as per I know its not a good approach to use 3 dim in the chart and since your combining the 2 and 3rd dimension it's creating the unique key combination ...try to use trellises

Re: Legend in qlikview bar chart

pooja_prabhu_n — Thu, 08 Feb 2018 06:41:35 GMT

Hi Avinash,

Thanks for your replay. My requirement is to display project as legend in the chart. I can remove the project from key combination and just keep "Key" as the 2nd dimension.

I can not use trellis. can you suggest any work around for this.

Thanks,

Pooja