Expression independent from dimension

[Anonymous]

I want to form a chart/table where I can view my cost values. And in addition I want to add a column where I can view cost/revenue. SO since my Cost is filtered in my measure (measureID, by selection, I need to make revenue independent from that filter, while it still obeys date,etc.

easureID, date, value

cost1, 1/1/2017, 10

cost2, 1/1/2017, 33

cost3, 1/1/2017, 23

revenenue, 1/1/2017, 100

...

I've tried the following. But it seems to be stilled overruled by my measureID selection.

sum(value) / Sum({<[measureID]={'revenue'}>} value)

[sunny_talwar]

Try this

Sum(value)/Sum(TOTAL {<[measureID]={'revenue'}>} value)

[Anonymous]

thanks stalwar1‌ .   but TOTAL didn't work.  I discovered that the following expression gets me closer (i.e. Sum(value)/Sum(1{<[measureID]={'revenue'}>} value) )

However, that also doesnt work  becasue it makes my expression indepent of everyhing (year, brand,etc.)

[sunny_talwar]

You mean this

Sum(value)/Sum({1<[measureID]={'revenue'}>} value)

What is the output you are looking to get?

[sunny_talwar]

Also, check this out

https://community.qlikview.com/blogs/qlikviewdesignblog/2013/09/09/aggregation-scope