topic Re: Between Date in Set Analysis in QlikView

Between Date in Set Analysis

Mon, 17 Mar 2014 20:00:46 GMT

Hi All

Thanks very much in advance

I am trying to sum of amount for date which between

=Sum({<LItem= {'Net Charge'}, xDate = {">=$(=MonthStart(AddMonths(GDate, -12))) <=$(MonthEnd(Addmonths(GDate, -1)))"}>} Amount)

(Some problem in above Set Ana

Any idea please

Thanks

Re: Between Date in Set Analysis

Nicole-Smith — Mon, 17 Mar 2014 20:05:14 GMT

You're missing an = in the second dollar sign expansion:

=Sum({<LItem= {'Net Charge'}, xDate = {">=$(=MonthStart(AddMonths(GDate, -12)))<=$(=MonthEnd(Addmonths(GDate, -1)))"}>} Amount)

Re: Between Date in Set Analysis

Mon, 17 Mar 2014 20:49:34 GMT

Let me clarify please

GDate is DIMENSION here

I need total AMOUNT for last 12 months based on GDate

Meaning

xDate >= AddMonth(gDate, -12) and xDate <= gDate

No variable here

Still not work

Re: Between Date in Set Analysis

Nicole-Smith — Tue, 18 Mar 2014 12:29:30 GMT

If GDate is your dimension, you can't sum values for other GDates, even by putting it in the set analysis. You either need to change your dimension, or look at calculating it in the script.

Re: Between Date in Set Analysis

Tue, 18 Mar 2014 21:26:16 GMT

Hi Nicole

I appreciate your efforts and valuable help

Here

GDate is dimension but I am using xDate and xBalance from another table

GDate is for comparison only

Thanks