topic Re: How to convert Table values to pie chart in QlikView

How to convert Table values to pie chart

saivina2920 — Sat, 16 Nov 2024 03:30:54 GMT

I am using Table Chart.

I just want to convert in to PIE Chart. I tried but, the value is not coming.

In the Pie chart, count should be display as below.

< 5 Days - Count

10 to 20 Days - Count

> 20 Days - Count

How to do this in pie chart from Table chart..?

pls. find sample Qlikview file.

pls. respond immediately. this is urgent.

Re: How to convert Table values to pie chart

aditi-dhooria — Wed, 22 May 2019 06:29:45 GMT

Hi,

Add more data in your inline table. PFA QVW with updated records in table.

Re: How to convert Table values to pie chart

saivina2920 — Wed, 22 May 2019 11:04:49 GMT

Thanks for your immediate help.
I have one more condition to pass in the Expression.
End user either select or enter some number in user input box or select from dropdown list.
based on the selection or enter value, then my count automatically should change.
For Example,
if i select some number from SeqDays (dropdown list), then my count should get changed.
I created one variable and assign those variable to "SeqDays" dropdown list.
vUserInput =GetFieldSelections(SeqDays)

I have applied for one expression in a PIE CHART (i.e) ==> < 5 Days.
below is my expression.
=Count({<NewDate={">=$(vCalDate)<=$(vToday) + $(vUserInput)"}>} NewDate)

I just want to add "vUserInput" in to the condition.
It is not working. count will not be changing based on my "SeqDays" selection.

What might be the problem.?????

pls. find attached sample file with condition i used...

Re: How to convert Table values to pie chart

saivina2920 — Wed, 22 May 2019 12:54:48 GMT

Any update. i'm struggling to get the values from dropdown list variables...

pls. respond..

Re: How to convert Table values to pie chart

saivina2920 — Wed, 22 May 2019 17:15:26 GMT

Any updates...

Re: How to convert Table values to pie chart

saivina2920 — Fri, 24 May 2019 09:21:15 GMT

Can you pls. anyone to update and give us the solution...