topic Re: Legend problem in QlikView

Legend problem

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have task ( prod, Mgmt, purchase) in chart. I have taken it against Country in dimension.

in Expression =Sum({<Task={'prod','Mgmt}>}Amount). Its working fine but

in Legend shows all the Task. I want to show only prod, mgmt. as I have taken sum of that.

please help me on this.

Thanks in ADV

Re: Legend problem

avinashelite — Wed, 21 Jun 2017 10:41:36 GMT

Ideal it should not give ...have to checked the suppress null and zero values in the presentation tab

Re: Legend problem

Anil_Babu_Samineni — Wed, 21 Jun 2017 11:38:01 GMT

But, You are taken Country as Dimension not the Task. How task will up and you in legend. Will you able to show image at least to check the same

Re: Legend problem

Thu, 22 Jun 2017 12:52:53 GMT

I have taken 2 dimensions Country & Task.

@ Avinash Suppressing works but same time I want to country should show there weather it is 0 or not. because I have created other chart in that way.

Re: Legend problem

avinashelite — Thu, 22 Jun 2017 13:24:27 GMT

we don't have selective feature to show the zero of one and not for others in your case its will be illogical rite ..

if the country is 0 for purchase then still you want to show but 2 nd dimension Task you don't ....if want the same then add a agg() dimension on the task that's will help you to achieve this