If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi. I want to calculate number of cases that has been taking between 6 months-12 months. I also want to calculate number of cases which took less than 6 months.
I calculated the time for the different cases by this formula: (Interval([c_enddate]-[c_startdate],'d')) as result,
c_enddate is when the project is done, and c_startdate when it starts.
End result sholud be something like:
Groups: 0-6 months: 6-12 months: >12 months
Nr of cases: 500 600 400
Any suggestions? I have tried with intervalmatch, set analysis and a whileloop but without succeding yet.
help would be greatly appreciated.
While loading data you need to create a buckets like this post
Try using if, IntervalMatch or class Functions
Hi. Thanks. I already tried that so would be Great if someone could provide an example-script with my field-names?
Let vDiff = ((year([c_enddate])*12)+month([c_enddate])) - (((year([c_startdate])*12)+month([c_startdate])));
IF($(vDiff)>=0 and $(vDiff)<=6 ,'0 - 6 Months',IF($(vDiff)>=7 and $(vDiff)<=12 ,'7 - 12 Months','>12 Months')) as Difference Bucket
Hope this helps