topic set analysis or if help in QlikView

set analysis or if help

userid128223 — Thu, 20 Jun 2013 17:31:03 GMT

I have a input box that defines sales limit.

I am trying to get total sales restricting by past 3 months from current date (today). + restrict by above input box. Below is what i did without sucess.

=sum({<user={doug},ReadingDate = {'>=$(=ADDMONTHS(TODAY(),-03))'}>}sales)

I put a dimension limit "show only value that are greter use the variable name for input box.

however the above is not work. Please let me know what could be the issue.

ReadingDate format = YYYY-MM-DD (could this format be creating an issue)

How can i achieve the above via if statement. What is better using if or set analysis.

Re: set analysis or if help

Gysbert_Wassenaar — Thu, 20 Jun 2013 18:11:34 GMT

Try =sum({<user={'doug'},ReadingDate={'>=$(=date(ADDMONTHS(TODAY(),-3)))'}>}sales)

If that doesn't work please read Preparing examples for Upload - Reduction and Data Scrambling

Re: set analysis or if help

userid128223 — Thu, 20 Jun 2013 18:29:02 GMT

Thanks Gysbert.

This worked after I adjusted my date format. i think that was the main issue.

if you were to find out past 40 days instead of 3 months how would you adjust the formula.
Can this formula be done wiht if statement, is if prefered over setanalysis.

Re: set analysis or if help

Gysbert_Wassenaar — Thu, 20 Jun 2013 18:37:54 GMT

1. simply subtract 40 days from today: date(today()-40)

2. a set analysis expression is to be prefered over an if statement, i.e. takes less cpu time to calculate.