Discussion Board for collaboration on QlikView Layout & Visualizations.
I have attached sample .QVW with data, In this I want find contribution of each category with respect to total.
So, in Layman term formula is: Amount/Total Amount.
Can you please guide me how to do this . . .
Thanks in advance . . .
Go to Solution.
I think you need a Contribution with Weeks
Sum / Total is like
and if you add few more Dimensions just add this
sum(Amount)/sum(TOTAL <Week> Amount)
i think this might help you find the attachment
I assume you mean the total of each week. Please find attached if that is the case.
Thank you Rohit & Jon , for such quick reply . . .