Discussion Board for collaboration related to Creating Analytics for QlikView.
I am very new to qlikview, currently i am facing a problem on how to filtering the data and represent them in my pie chart.
this my excel file
then i want create a pie chart that shows 3 groups of age which are (age <=3 , 3 < age < 5 and age >= 5 ).
the pie chart should look like this..
Go to Solution.
kindly find the attached file.
i hope it will help you.
Thank you for your generous help, but
I cannot open your file as it stated
Could you please to explain to me how to overcome this issue? or write the syntax here?
Go to Edit Script,
LOAD * Inline [
if(Match(Age,4),'3 < age < 5',
if(Match(Age,5,6,7,8),' age >= 5'))) as Age_Range
Create Pie chart with Dimension as Age_Range and Expression as Count(Age)
Hope it will make you help.
You can even use Buckets
LOAD *, class(Age,3) as Bucket;
LOAD * Inline
Chart Type Pie Chart