topic Re: Multiple conditions in set analysis expression in QlikView

Multiple conditions in set analysis expression

Anonymous — Mon, 04 Nov 2013 15:58:03 GMT

Hi,

I would like to present my sales statistics in a straight table the past 12 months...

Which is the best way to do that using set analysis??

I have this year as a default selection in my document.

sum({$<MyYear={$(=Only(MyYear)), $(=Only(MyYear)-1)}>} MyAmount)

This code gives me this year's (2013) sales + the sales of the whole 2012... I only want november and december from 2012, or even better, the sales from 5/11/2012 as that is on the day correct...

Any thoughts about this?

Thanks in advance.

Best regards,

Filip

Re: Multiple conditions in set analysis expression

jvitantonio — Mon, 04 Nov 2013 16:01:24 GMT

Hi, Try this:

=sum({<MyDate= {"<=today(), >=today()-365"}>} [MyAmount])

MyDate is a field containing the date.

Re: Multiple conditions in set analysis expression

Gysbert_Wassenaar — Mon, 04 Nov 2013 16:20:21 GMT

Assuming you have a date field try: sum({$<MyDate={'>$(=addyears(today(),-1))'}>} MyAmount).

Re: Multiple conditions in set analysis expression

Anonymous — Wed, 06 Nov 2013 16:12:45 GMT

Thank you for your posts, but unfortunately none of these examples helps me..

I've read a lot of possible solutions, but just can't get it work...

Any other suggestions?

Re: Multiple conditions in set analysis expression

Anonymous — Wed, 06 Nov 2013 16:30:40 GMT

I really think this should work.

But I am only getting the values from this year... I have data with invoice date '2012-12-10' for example, but I won't reach it for some reason....

Re: Multiple conditions in set analysis expression

Gysbert_Wassenaar — Wed, 06 Nov 2013 16:39:59 GMT

That sounds like you have a Year field and selected 2013. In that case you need to change the set modifier so the selection in the Year field is ignored. Try sum({$<Year=, MyDate={'>$(=addyears(today(),-1))'}>} MyAmount)

Re: Multiple conditions in set analysis expression

Anonymous — Thu, 07 Nov 2013 10:14:17 GMT

Thank you a lot, that was what I was looking for!