considering and not considering the dimension in the same formula

[#1]

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.

[brenner_martina]

Hi, F.

could this help?

Sum(Amount)/Sum(Total TICKETS)

Greetings from Munich

Martina