Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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.