topic Re: Set analysis with date between in QlikView

Set analysis with date between

Fri, 24 Jul 2015 13:26:48 GMT

Hello, guys!

I have a problem with set analysis, I need to create an expression with the average of values for the period from January till Month picked by user in the filter.

I created and expression: AVG({<Month_Date={">=$(=Min({1}Month_Date))<=$(=Max(Month_Date)"},Month_name=>}(Bench_Data*Forecast)), but it's not working,

May be I have some syntax error?

Please help!

Sample app is attached

Re: Set analysis with date between

marcus_sommer — Fri, 24 Jul 2015 13:39:13 GMT

You have a 1 within the set analysis which meant to ignore user selections. You need to remove it:

AVG({<Month_Date={">=$(=Min({1}Month_Date))<=$(=Max(Month_Date)"},Month_name=>}(Bench_Data*Forecast))

- Marcus

Re: Set analysis with date between

swuehl — Fri, 24 Jul 2015 13:55:33 GMT

There is just a closing bracket missing:

AVG({<Month_Date={">=$(=Min({1}Month_Date))<=$(=Max(Month_Date))"},Month_name=>}(Bench_Data*Forecast))

Not sure if the logic is correct since min Month_Date is Jan-14.

Re: Set analysis with date between

Fri, 24 Jul 2015 14:23:54 GMT

Yes, You're absolutely correct. It's not right, I need to set as min date Jan-15.

How can I insert this condition in my Set analysis?

Re: Set analysis with date between

swuehl — Fri, 24 Jul 2015 14:29:21 GMT

Not sure, maybe like

AVG({<Month_Date={">=$(=Date(yearstart(today()),'MMM-YY'))<=$(=Max(Month_Date))"},Month_name=>}(Bench_Data*Forecast))