Set Analysis Query

[anthony_kinsell]

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]

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

[jonathandienst]

Correction:

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

[er_mohit]

Try this

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

[maxgro]

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]

What is your vBudget2 variable expression?

[anthony_kinsell]

What's the difference?

[maxgro]

in the attachment

[anthony_kinsell]

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

[MK_QSL]

Kindly load your sample qvw.