Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
LWeisz
Contributor
Contributor

How to create a pie chart with buckets?

The pie chart measure is cycle time.  The pie chart segments should be cycle time buckets: for example <30 days, 30 - 45 days and > 45 days.  Any guidance is much appreciated.

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

You need to either create these buckets in the load script
or use value list https://community.qlik.com/t5/Qlik-Design-Blog/ValueList-For-those-tricky-situations/ba-p/1476275
pradosh_thakur
Master II
Master II

something smilar to these
assuming you have days in [cycle time]
pick(match(-1, [cycle time]<30, [cycle time]>=30 and [cycle time] <45 , [cycle time] > 45),
'<30 days',' 30 - 45 days' ,' > 45 days')

Learning never stops.