topic Re: question about set expression in QlikView

question about set expression

Anonymous — Mon, 16 Mar 2015 13:44:33 GMT

Hi,

If I need to calculate the Budget for Category 1 only I can use the following expression:

sum ({<Categories = {'Category1'}>} [Budget])

But my task is to calculate quite the opposite - all other categiries except Category1.

How should I change this expression so that I could calculate the Budget for all other Categories except Category1?

Thank you in advance,

Larisa Filonova

Mon, 16 Mar 2015 13:45:35 GMT

sum ({<Categories -= {'Category1'}>} [Budget])

It'll give you a syntax error but ignore it, syntax checker doesn't like the -= part even though it works fine.

maleksafa — Mon, 16 Mar 2015 13:47:36 GMT

sum ({<Categories -= {'Category1'}>} [Budget])

-= instead of =

rubenmarin — Mon, 16 Mar 2015 13:48:40 GMT

Hi Larisa, you can use:

sum ({<Categories = Categories-{'Category1'}>} [Budget])

sum ({<Categories -= {'Category1'}>} [Budget])

sum ({<Categories = {"*"}-{'Category1'}>} [Budget])