topic Re: Date variable in expression in QlikView

Date variable in expression

Mon, 03 Mar 2014 17:37:05 GMT

Hi All

I have been selecting variable (vDate) but with below vDate does not refreshed

G_date and Balance comes from Data where vDate is Variable

In below example if vDate = '12/31/2013' so I should get Summed Balance as of 9/30/2013 but it shows me as of 12/31/2013

sum({<G_Date= {'=QuarterEnd(Addmonths(vDate, -3))'}>} Balance)

Your helps are appreciated

Thanking you

Kumar

Re: Date variable in expression

Mon, 03 Mar 2014 17:39:14 GMT

$(vDate) perhaps

Fabrice

Re: Date variable in expression

Peter_Cammaert — Mon, 03 Mar 2014 17:47:08 GMT

There is more to this. Expansion will not work because the replacement code between quotes is incorrect. Also, if you plainly use $(vDate), then you may end up with a value of 9 divided by 30 divided by 2013 which is ... um.... very small.

Try this:

=sum({<G_Date= {">=$(=QuarterEnd(Addmonths('$(vDate)', -3)))"}>} Balance)

Best,

Peter

Re: Date variable in expression

Mon, 03 Mar 2014 18:13:30 GMT

Thanks for your help and

Sorry for modification, basically I want to pick the balance from previous quarter end date. So I tried to sum for particular 09/30/2013. So let say if there is balance $125 for 09/30/2013. So I want to print this.

Sorry for inconvinience

Thanks again

Re: Date variable in expression

Mon, 03 Mar 2014 18:25:45 GMT

Sorry for inconvinience

Thanks again

Re: Date variable in expression

Peter_Cammaert — Mon, 03 Mar 2014 20:57:27 GMT

OK, minor modification to the previous one:

=sum({<G_Date= {"$(=QuarterEnd(Addmonths('$(vDate)', -3)))"}>} Balance)