Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sales Range

Hi All,

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.

Row LabelsCount of Sku
No Sales38
1  mio - 4.9 mio919
5 mio - 9.9 mio393
10 mio - 19.9 mio309
20 mio - 39.9 mio201
40 mio - 69.9 mio94
70 mio - 99.9 mio29
100 mio - 199.9 mio18
200 mio - 299.9 mio3
300 mio - 399.9 mio2
400 mio - 499.9 mio1

Thanks for help

Henry

6 Replies
vigneshvs
Creator II
Creator II

Hi

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.

Thanks,

Vignesh

Not applicable
Author

HI Vignesh,

I am not see the changes from my previous file? did you save ?

Please advice

Thanks

Henry

vigneshvs
Creator II
Creator II

Hi Henry,

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,

Vignesh

Not applicable
Author

Hi Vignesh,

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 ?

Thanks

vigneshvs
Creator II
Creator II

Hi Henry,

Check for each id_produck the minimum sales and maximum sales value which will solve the data grouping issue.

or

Post the sample QS file which have this problem.

Thanks,

Vignesh

Not applicable
Author

Hi Vignesh,

I attach the file.

Thanks

Henry