topic Re: Greater than variable in set analysis in QlikView

Greater than variable in set analysis

annabergendal — Tue, 26 Feb 2019 20:58:30 GMT

I have a variable with current Year-Week that I use successfully in set analysis:

sum({$<ÅrVecka={"$(=$(vG.CurrentWeek))"}>}Sales)

Now, I want to convert it to greater than, but I cannot make it work, should be simple, please advise!

tincholiver — Tue, 26 Feb 2019 21:05:46 GMT

Try this

sum({$<ÅrVecka={">=$(vG.CurrentWeek))"}>}Sales)

annabergendal — Tue, 26 Feb 2019 21:27:51 GMT

Doesn't work unfortunately

tincholiver — Tue, 26 Feb 2019 21:29:39 GMT

Can you share de app?

tincholiver — Tue, 26 Feb 2019 22:41:22 GMT

Sorry, the expression had a bad parenthesis,

sum({$<ÅrVecka={">=$(vG.CurrentWeek)"}>}Sales)

tell me if it keeps throwing an error?

annabergendal — Wed, 27 Feb 2019 07:43:32 GMT

It gives me just 0... I will see if I can share the app later.