topic analysing sales in interval in QlikView

analysing sales in interval

Fri, 27 Nov 2009 19:40:51 GMT

hi,

i want to create a straight chart which analyze sales in intervals (like $00000 <=sales< $100000, $100000<= sales< $500000 etc) .

how can i create this fixed interval to analyze different fields like no. of customers, total sales, total orders etc. for each interval.

Fri, 27 Nov 2009 19:59:11 GMT

You can use "calculated dimention" in charts:

=class( sales, 100000, 'sales' )

or add string inside LOAD statement:

class( sales, 100000, 'sales' ) as [AnalyzingInterval],

Mon, 30 Nov 2009 18:21:13 GMT

thanx for ur reply,

as per ur suggestion i have added following in calculated dimension

=class(SALE_ITEM_NETAMT,100000,'SALES') this leads to two problems:-

1) the interval is not continuous i.e. 0<=SALES<100000, 100000<=SALES<200000 Then 800000<=SALES<900000 etc.

2)sum of no. of customers and orders corresponding to intervals differ from sum showing at the end.

please suggest answer.