Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
saivina2920
Creator
Creator

How to convert Table values to pie chart

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.

 

Labels (1)
5 Replies
aditi-dhooria
Contributor
Contributor

Hi, 

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

saivina2920
Creator
Creator
Author

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

saivina2920
Creator
Creator
Author

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

pls. respond..

saivina2920
Creator
Creator
Author

Any updates...

saivina2920
Creator
Creator
Author

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