topic Re: Set Analysis Query in QlikView

Set Analysis Query

anthony_kinsell — Wed, 19 Feb 2014 12:18:12 GMT

Hi,

I'm still relatively new to Qlikview & set analysis - so apologies if this is a stupid question.

I'm using the below formula as part of a larger formula & it works fine:

sum({$<FundHeading={"*Sales*"},Scenario={$(vBudget2)}>}(DevBudgetAmount+0.01)*-1)

My query is how could I do this where the fund heading didn't contain 'Sales'? The below doesn't work:

sum({$<FundHeading<>{"*Sales*"},Scenario={$(vBudget2)}>}(DevBudgetAmount+0.01)*-1)

maxgro — Wed, 19 Feb 2014 12:22:44 GMT

sum({$<FundHeading=-{"*Sales*"},Scenario={$(vBudget2)}>}(DevBudgetAmount+0.01)*-1)

jonathandienst — Wed, 19 Feb 2014 12:26:28 GMT

Correction:

sum({$<FundHeading-={"*Sales*"},Scenario={$(vBudget2)}>}(DevBudgetAmount+0.01)*-1)

er_mohit — Wed, 19 Feb 2014 12:35:08 GMT

Try this

sum({$<FundHeading={'*Sales*'},Scenario={'=$(=vBudget2)'}>}DevBudgetAmount+0.01)*-1)

maxgro — Wed, 19 Feb 2014 12:40:38 GMT

If I'm not wrong

The first =- selects all fund heading except '*Sales*'

The second -= removes from the current selection all fund heading with '*Sales*'

MK_QSL — Wed, 19 Feb 2014 13:19:37 GMT

What is your vBudget2 variable expression?

anthony_kinsell — Wed, 19 Feb 2014 14:20:12 GMT

What's the difference?

maxgro — Wed, 19 Feb 2014 14:37:21 GMT

in the attachment

anthony_kinsell — Thu, 20 Feb 2014 16:40:05 GMT

Anyone else any suggestions? None of the above seem to have worked

MK_QSL — Thu, 20 Feb 2014 16:54:21 GMT

Kindly load your sample qvw.