topic Re: Dynamic % of Total in Trend in QlikView

Dynamic % of Total in Trend

Mon, 04 Feb 2013 20:57:47 GMT

Hi All,

I’ve a trend report which is year month wise trended in pivot chart , Where I’ve two dimensions – Country and year month . For each month ,I need to calculate the current month sales / total of current month sales . Also based on year month filter selection the trend should vary but each month I need a total should be 100 .

I’ve tried with sum(sales)/sum(total sales) but its not working out.

sum(total sales) should varying but I need this to be specific for that month and hence only I can get the total as 100. Could anyone please help me how to aggregate ?

Sales
Country	201201
A	1000
B	2000
C	3000
D	4000
Total	10000

Sum(Sales)/Sum(total sales)
	% of total
Country	201201	201202	201203	201204
A	10
B	20
C	30
D	40
Total	100

Thanks,

Re: Dynamic % of Total in Trend

Mon, 04 Feb 2013 23:37:39 GMT

I really needed your inputs

Thank you.

Re: Dynamic % of Total in Trend

Wed, 06 Feb 2013 06:15:31 GMT

any suggestion ?

Re: Dynamic % of Total in Trend

Wed, 06 Feb 2013 06:38:03 GMT

Can you please attach a sample app with the required Output ..

I could not understand the exact OutPut that is expected from the above Post..

Re: Dynamic % of Total in Trend

Wed, 06 Feb 2013 07:13:42 GMT

Hi ,

I've attached the application . Thanks .

Re: Dynamic % of Total in Trend

Thu, 07 Feb 2013 06:12:24 GMT

Hi ,

Please find the Attached App..

Hope it helps you..

Re: Dynamic % of Total in Trend

Thu, 07 Feb 2013 07:11:12 GMT

tab:

LOAD [year/Month],

Country,

sales

FROM

C:\Users\vishwaranjan\Desktop\Sales.xlsx

(ooxml, embedded labels, table is Sheet1);

Generic LOAD Country, [year/Month],sales Resident tab;

then take pivote table

dimension- country

expression1- Sum( [201201])

expression2- Sum(([201201]*100) / 7000)

expression3- sum([201202])

expression4- Sum(([201202]*100) / 10000)

and presentation select country check on partial sum

then output like this

Country	201201	% Total of 201201	201202	% Total of 201202
A	1000	14.29	7000	70
B	2000	28.57	1000	10
C	4000	57.14	2000	20
Total	7000	100.00	10000	100

Re: Dynamic % of Total in Trend

er_mohit — Thu, 07 Feb 2013 07:33:07 GMT

hii see the attached file

Re: Dynamic % of Total in Trend

Thu, 07 Feb 2013 16:38:21 GMT

Thanks a lot for your suggestions . Spl thanks to Bhaskar