PIE CHART Case timetable

[apinto]

Hello guys , 

Im going through the demos, Someone know how I can do a pie char based on certain timetables like this one?

[sidhiq91]

@apinto it is definitely possible, but please provide us some sample data. I can work on it and give you the solution.

[apinto]

Hello @sidhiq91 , Thank you for your disponibility, 

I just uploaded my data, and I would like to see for example the create date (*count) by  case timetable. 

Thank you

[sidhiq91 · Accepted solution]

@apinto  You can try something like below:

In the back end:

Temp:
LOAD
"Issue ID",
Date(Created,'MM/DD/YYYY') as CreatedDate,
Date(Updated,'MM/DD/YYYY') as UpdatedDate

FROM [lib://Qlik Community Practice/Qlik pie chart.xlsx]
(ooxml, embedded labels, table is Sheet1);

NoConcatenate
Temp1:
Load *,
Interval(UpdatedDate-CreatedDate,'DD') as Interval,
if(Interval(UpdatedDate-CreatedDate,'DD')=0,'Same Day',
if(Interval(UpdatedDate-CreatedDate,'DD')=1,'1 Day',
if(Interval(UpdatedDate-CreatedDate,'DD')>=02 and Interval(UpdatedDate-CreatedDate,'DD')<=07 ,
'2-7 Day',
if(Interval(UpdatedDate-CreatedDate,'DD')>=08 and Interval(UpdatedDate-CreatedDate,'DD')<=14 ,
'8-14 Day',
if(Interval(UpdatedDate-CreatedDate,'DD')>15 and Interval(UpdatedDate-CreatedDate,'DD')<=21 ,
'15-21 Day',
if(Interval(UpdatedDate-CreatedDate,'DD')>22 and Interval(UpdatedDate-CreatedDate,'DD')<=31 ,
'15-21 Day','Older than a month')))))) as Condition
Resident Temp;

Drop table Temp;

Exit Script;

In the Front End:

Dimension:Condition

Measure: Count([Issue ID])

[apinto]

@sidhiq91  Thank you so much for the help 🙂 !