How to use class function in dimension

Thu, 28 Nov 2013 08:37:46 GMT

Hi,

I have some sales histories by different customer ID and I want to classify their total spending in different intervals in a straight table. This is the result after I filter a particular customer with 11 repeat purchases but what I want is to group all transactions in one single line with total sales in 46K.

Spending	Net sales	AUR	Tx Count	IPT
	46K	2,541	11	1.6
1-3,000	6K	1,419	3	1.3
3,001-6,000	22K	2,229	6	1.7
6,001-9,000	6K	3,029	1	2.0
9,001-12,000	12K	5,856	1	2.0

This is the calculated dimension I am using and I've tried different way, like using Sum([Invoice Net Amount in HKD]) or Aggr() to group invoice amount by customer ID but no luck.

=Dual(num(SubField(Class([Invoice Net Amount in HKD],vSpendingInterval*1000)+1,' ',1),'#,##0')&'-'&num(SubField(Class([Invoice Net Amount in HKD],vSpendingInterval*1000),' ',5),'#,##0'),

num(SubField(Class([Invoice Net Amount in HKD],vSpendingInterval*1000),' ',1),'#,##0'))

Re: How to use class function in dimension

Thu, 28 Nov 2013 09:07:44 GMT

Please PUT some of your raw data and desired output so that format of your table data and necessary function usage can be understood.

topic Re: How to use class function in dimension in QlikView

How to use class function in dimension

Re: How to use class function in dimension