Hello everyone,
I am a begginer at Qlikview and I suppose that should be an easy one.
I would like to divide a SUM which is related to the dimension of the line, but divide it per another SUM which is not related to the dimensions (the REAL total) - and both of them still have to attend for the filters (filters here are Year and Week)
Being more specific:
- I have the sum of revenue values, and for each line (dimension) it shows me the amount for that dimension - easy, working fine
- I want to divide this sums per the TOTAL amount of TICKETS (it's another value that I can aswell create easily)
I've been trying to use something like SUM({1<Dimension1=, Year={$(=Max(Year))}, Week={$(=Max(Week))}>} TICKETS)
(I thought that would give me total sum of the TICKETS, without considering the Dimension, but considering the Year and Week I am clicking on...)
Thanks for the attention!
F.
