topic Re: How to show the legend with values in pie chart in QlikView

How to show the legend with values in pie chart

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

Hello Experts,

I want to show the legend with values in pie chart. Below i am attaching images

For this out put i used Dimension: Skillname

Expression1:=Sum({<[Closed date] = {"$(='>=' & Date(Today()-30))"},[Job Status]={Closed}>} [Total No. of Openings])

Expression2:==Sum({<[Closed date] = {"$(='>=' & Date(Today()-30))"},[Job Status]={Closed}>} [Ageing in days])

But i want to show the openings also in legend

For example like this i want

.NET-1

Consulting-1

Can you guys help me for this

Thank you in advance

Regards,

B V S Sudhakar

Re: How to show the legend with values in pie chart

tresB — Mon, 20 Aug 2018 08:21:47 GMT

In the presentation tab, check 'Show Numbers in Legend'

Re: How to show the legend with values in pie chart

bvssudhakar — Mon, 20 Aug 2018 08:52:23 GMT

Hi Tresesco,

I tried with that option already, In that case i don't want this expression values in chart because once see the chart it is showing both expression values but i don't want below mentioned expression values and i want those values in legend

Expression1:=Sum({<[Closed date] = {"$(='>=' & Date(Today()-30))"},[Job Status]={Closed}>} [Total No. of Openings])

Re: How to show the legend with values in pie chart

Sergey_Shuklin — Mon, 20 Aug 2018 09:09:02 GMT

Hello, Sudhakar!

Like this?

If so - just add to your dimension formula this part: Skillname &' - '& aggr(Count(Openings), Skillname)

Re: How to show the legend with values in pie chart

bvssudhakar — Mon, 20 Aug 2018 09:20:12 GMT

HI Sergey Shuklin,

What you show in legend i want that output but i don't want those values in chart

Re: How to show the legend with values in pie chart

Sergey_Shuklin — Mon, 20 Aug 2018 09:26:05 GMT

Ok, so in Expression tab you just need to uncheck "values on data points" in the expression with openings

Re: How to show the legend with values in pie chart

bvssudhakar — Mon, 20 Aug 2018 10:02:51 GMT

Hi Sergey Shuklin,

Thank you, I am checking all options except that.

Thank you very much for remembering that silly thing