Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic % of Total in Trend

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,

1 Solution

Accepted Solutions
Not applicable
Author

Hi ,

Please find the Attached App..

Hope it helps you..

View solution in original post

8 Replies
Not applicable
Author

I really needed your inputs

Thank you.

Not applicable
Author

any suggestion ?

Not applicable
Author

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..

Not applicable
Author

Hi ,

I've attached the application . Thanks .

Not applicable
Author

Hi ,

Please find the Attached App..

Hope it helps you..

Not applicable
Author

hi

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

Country201201% Total of 201201201202% Total of 201202
A100014.29700070
B200028.57100010
C400057.14200020
Total7000100.0010000100
er_mohit
Master II
Master II

hii see the attached file

Not applicable
Author

Thanks a lot for your suggestions . Spl thanks to Bhaskar