topic Re: Set Analysis Query 2 in QlikView

Set Analysis Query 2

anthony_kinsell — Wed, 19 Feb 2014 15:59:22 GMT

Hi,

I'm trying to get the total for my 'DevBudgetAmount' field for the "Rolling" budget scenario no matter what date selection is made - I've tried the below but it's not correct - can anyone point me in teh right direction?

sum({1}{$<Scenario={"Rolling"}>}DevBudgetAmount*-1)

Re: Set Analysis Query 2

jerem1234 — Wed, 19 Feb 2014 16:01:25 GMT

Maybe:

sum({<Scenario={"Rolling"}, Date=>}DevBudgetAmount*-1)

where Date is your Date field.

Re: Set Analysis Query 2

chiru_thota — Wed, 19 Feb 2014 16:05:09 GMT

sum({<Scenario={"Rolling"}>} TOTAL <Dimension1,Dimension2>DevBudgetAmount*-1)

Don't mention Date column in TOTAL <>.

This will sum up the data irrespective of Date.

Re: Set Analysis Query 2

anthony_kinsell — Wed, 19 Feb 2014 16:09:57 GMT

This sums the data but doesn't take into account different dimensions

Re: Set Analysis Query 2

anthony_kinsell — Thu, 20 Feb 2014 16:42:22 GMT

Anyone else got a suggestion?

Re: Set Analysis Query 2

jerem1234 — Thu, 20 Feb 2014 16:54:29 GMT

Maybe:

sum({1<Scenario={"Rolling"}>}DevBudgetAmount*-1)

If this doesn't work, can you explain why it isn't working, what the behavior is when you use this?

Even better, post a sample app demonstrating the problem so people may help you faster.

Hope this helps!

Re: Set Analysis Query 2

anthony_kinsell — Thu, 20 Feb 2014 16:59:26 GMT

That's is

Thank you