
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Quintile Analysis
Hello,
I am new to Qlik Sense and this is my first projet alone. I need to make an analysis where users are bucketed in quintiles for the total number of calls. The number of calls is variable resulting from the total number of F2F interactions and Video interactions.
= if(($(vTotalCalls))<= fractile(Total ($(vTotalCalls),0.20)), 1,
if( ($(vTotalCalls)) <= fractile(Total ($(vTotalCalls)), 0.40), 2,
if( ($(vTotalCalls)) <= fractile(Total ($(vTotalCalls)), 0.60), 3,
if( ($(vTotalCalls)) <= fractile(Total ($(vTotalCalls)), 0.80), 4, 5))))
The result is an invalid dimension. What am I missing?
Many thanks in advance
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perhaps you can benefit from some built in tools to build out your solution?
- https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/Grouping-measur...
- https://www.youtube.com/watch?v=Nhdum6XQudA
Just a thought...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perhaps you can benefit from some built in tools to build out your solution?
- https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/Grouping-measur...
- https://www.youtube.com/watch?v=Nhdum6XQudA
Just a thought...
