topic Re: Expression problem in QlikView

Expression problem

Tue, 26 Mar 2013 15:04:05 GMT

Hi all,

I am trying to get the sum of "Supply OG" where it does not take into account the year selected and only displays that of "Saurian Petroleum"

Here is my expression, when I just have the year section it works but shows all companies and when I add in the Saurian Petroleum section it only returns the values of Saurian but now also only returns the values for the currently selected year.

Sum

( {<Year=>} {$<Company={[Saurian Petroleum]}>} [Supply OG])

I am assuming there is a proper way to connect the two modifiers but I do not know the code.

Hopefully someone can help me.

Thanks,

Kosta

Re: Expression problem

Tue, 26 Mar 2013 15:07:59 GMT

try this

Sum

( {<Year=, Company={'[Saurian Petroleum]'}>} [Supply OG])

regards

chris

Re: Expression problem

Tue, 26 Mar 2013 15:09:15 GMT

You can add multiple filters within {<...>}, so try this:

Sum

( {<Year=,Company={[Saurian Petroleum]}>} [Supply OG])

Re: Expression problem

manideep78 — Tue, 26 Mar 2013 15:09:23 GMT

try this

Sum({$<Year=,Company={[Saurian Petroleum]}>}[Supply OG])

Re: Expression problem

Tue, 26 Mar 2013 15:14:55 GMT

try

Sum({$<Year=,Company={'Saurian Petroleum'}>}[Supply OG])

Regards

Borys