Legend count values not coming properly while converting from chart straight table to Pie Chart.

saivina2920 — Fri, 15 Nov 2024 23:17:21 GMT

I am trying to convert chart straight table to Pie chart.

I have used same dim/expressions for the pie chart.

But, the legend count values (1-10 days, 10-30 Days, > 30 days) not coming which is same used in chart straight table.

below is the dim/expressions

Dimensions

=If(vUserInput, if(IsNull(EMP_RELIEVE_DATE) AND [EMP_STATE]='$(vEmPlaces)', date(EMP_RESIGN_DATE),date(EMP_RELIEVE_DATE)), if(not IsNull(EMP_RELIEVE_DATE) AND EMP_RELIEVE_DATE <= floor(Today()) AND [EMP_STATE]='$(vEmPlaces)', EMP_RELIEVE_DATE))

Exp1 : "Relieving_Date" (LABEL TEXT)

=If(vUserInput, if(IsNull([EMP_RELIEVE_DATE]),Date(EMP_RESIGN_DATE+vUserInput),Date(EMP_RELIEVE_DATE)),if(not IsNull([EMP_RELIEVE_DATE]) AND EMP_RELIEVE_DATE <= floor(Today()) AND [EMP_STATE]='$(vEmPlaces)', EMP_RELIEVE_DATE))

Exp2 : 1-10 Days

if([Relieving_Date]>=vCalDate10 And [Relieving_Date]<=vToday AND [Relieving_Date] <= Today() AND [EMP_STATE]='$(vEmPlaces)',1,0)

Exp3: 10-30 Days

If([Relieving_Date]>=vCalDate30 And [Relieving_Date]<=vCalDate10 AND [Relieving_Date] <= Today() AND [EMP_STATE]='$(vEmPlaces)', 1,0)

Exp3: >30 Days

If([Relieving_Date]<=vCalDate30 AND [Relieving_Date] <= Today() AND [EMP_STATE]='$(vEmPlaces)', 1,0)

How to retrieve the count values and show the legend in pie chart.

Re: Legend count values not coming properly while converting from chart straight table to Pie Chart.

saivina2920 — Wed, 20 Jan 2021 02:00:40 GMT

can anyone give us the solution for this...?

topic Legend count values not coming properly while converting from chart straight table to Pie Chart. in QlikView

Legend count values not coming properly while converting from chart straight table to Pie Chart.

Re: Legend count values not coming properly while converting from chart straight table to Pie Chart.