topic Re: Expression independent from dimension in QlikView

Expression independent from dimension

Anonymous — Tue, 03 Oct 2017 07:26:13 GMT

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)

Re: Expression independent from dimention

sunny_talwar — Tue, 03 Oct 2017 15:45:23 GMT

Try this

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

Re: Expression independent from dimension

Anonymous — Wed, 04 Oct 2017 07:37:04 GMT

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.)

Re: Expression independent from dimension

sunny_talwar — Wed, 04 Oct 2017 16:21:57 GMT

You mean this

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

What is the output you are looking to get?

Re: Expression independent from dimension

sunny_talwar — Wed, 04 Oct 2017 16:25:51 GMT

Also, check this out

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