topic Re: Need to get Sum per Dimension week in QlikView

Need to get Sum per Dimension week

Fri, 21 Mar 2014 13:12:22 GMT

hello,

Can anyone help me to get the total sales per week(dimension) from the table below;

WeekNumber	Channel	Sales	Column that should return total of the week(Expected Results)
1	abc	0	20
1	asd	20	30
2	asd	30	30
3	sdgfds	40	220
3	sdfsd	50	220
3	bddvbv	60	220
3	lokpko	70	220

The idea is to have the repartition of the sales per week and per Channel. I used Aggr as shown below but the results are as follows:

Formula: sum(aggr(sum(sales),WeekNumber))

WeekNumber	Channel	Sales	Column that should return total of the week(Expected Result)	Used Aggr from QV
1	abc	0	30	30
1	asd	20	30	0
2	asd	30	30	30
3	sdgfds	40	220	220
3	sdfsd	50	220	0
3	bddvbv	60	220	0
3	lokpko	70	220	0

Thanks in advance,

Selen

jerem1234 — Fri, 21 Mar 2014 13:16:49 GMT

Try:

sum(total <WeekNumber> sales)

Hope this helps!

sunilkumarqv — Fri, 21 Mar 2014 13:32:13 GMT

try like these

sum(total sales)/Weeknumber

div(aggr(sum(total sales)),Weeknumber)

its_anandrjs — Fri, 21 Mar 2014 14:07:37 GMT

Hi,

use this expression

Aggr(sum(DISTINCT Sales),WeekNumber)

Hope this helps

Thanks & Regards

maxgro — Fri, 21 Mar 2014 22:59:35 GMT

did you mean week or week and channel?

sum(total <WeekNumber> sales)

sum(total <WeekNumber, Channel> sales)