Discussion board where members can get started with Qlik Sense.
I am still confused to create sales range, and really need your help in here
I have sku and sales data, and I want to group no of sku by sales range like below. I want to do in QS.
I attach QS file.
Thanks for help
The different sales range can be created using interval match function.
PFA the QS file. Reload it and check to get the same output as expected.
Hope this solve your problem.
I am not see the changes from my previous file? did you save ?
Yeah i do save the file..
The modification is done in the script.
Pls do reload the file from your machine and create a straight table having
dimension = range
measure = count(distinct Sku)
Attaching the file again FYR.
thanks for the info and yes the script is correct.
But when I am trying to connect to my data it doesn't work. I dont know why ?
Data grouping was not right. I have only 2 group.
I've already set the script like yours
LOAD * INLINE [
Start, End, Sales_Range
0,0 , No_Sales
1, 5000000, 1-5mio
5000001, 10000000, 5-10mio
10000001, 20000000, 10-20mio
20000001, 40000000, 20-40mio
40000001, 40000001++, >40
do you know why ?
Check for each id_produck the minimum sales and maximum sales value which will solve the data grouping issue.
Post the sample QS file which have this problem.
I attach the file.