topic Need help with expression filter in QlikView

Need help with expression filter

Anonymous — Wed, 30 Oct 2013 22:27:09 GMT

Hi,

I found out that there's another way to do aggregation based on a filter, I got this....

sum({<Period={"H211"}>} HC) this works just fine (and for a unknown reason, if statement is not working, maybe because it's nested with other formulas)

The thing is, is there anyway to make it flexible like

sum({<Period like "H2*">} HC)

Re: Need help with expression filter

Wed, 30 Oct 2013 22:31:35 GMT

Hi Oscar,

Have you tried sum({<Period={"H2*"}>} HC) ?

This should work if all you need is a wildcard search.

Kind regards

Andrei Popescu

Re: Need help with expression filter

Anonymous — Wed, 30 Oct 2013 22:34:09 GMT

Hi Andrei, that was it! I never tried that... shame on me, well thank you very much!