Legend in qlikview bar chart

[pooja_prabhu_n]

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

[jonathandienst]

>>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.

[avinashelite]

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

[pooja_prabhu_n]

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