Discussion board where members can get started with QlikView.
I'm quite new!
One question (I hope easy for you):
I have loaded into QLIK a table like the one below (for your convenience I've attached the completed Excel file).
I'd like to have in Qlik a column like the one named "TO BE CALCULATED" where I'd like to have the following formula:
VAL (row level) /TOTAL VAL (for this specific "PdV").
Example for the 1st row: 940 / 201945 = 0,47%
If you want to see the formula in Excel please open the attachment.
What's the expression I have to setup in QLIK to have back this result??
Thanks to everybody who can help me!!!
Go to Solution.
Hi Wal gno
The expression I used is Sum(VAL) / Sum(Total<PdV> VAL).
Since you don't want to totalize the year, I created a Straight Table Chart.
Try this app. I just don't know how to put the total for each year to 100%.
thanks for your reply.
One favour... since I have the free version of qlik and cannot open a file made by any other PC, could you be so kind to send me the expression you used.
one more remark: I don't want the total per year, I want each record of a specific "PdV" will be divided by the "total of Val" of this "PdV" .
For example for the Pdv = "007-Mer Sarzana" the result 0,22% will be calculated by the division 1.436/652.600.
In fact 1436 is the value of column "val" for this record, while 652.600 is the total of "Val column" values of the "PdV" called "007-Mer Sarzana".