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
