topic Re: Variables in Expressions in QlikView

Variables in Expressions

Anonymous — Fri, 29 Jan 2016 17:48:31 GMT

Hello,

I am looking to write an expression to sum totals of accounts with an opened date equal to or great than a specified time period.

assuming the period is December 31, 2014 to December 31, 2015

example:

=sum({<open_dt={$(vLastPeriod)}

,type = {'L','C'}

>} sales)

Can someone help with my expression to include greater than or equal to. The following did not work:

=sum({<open_dt={>=$(vLastPeriod)}

,type = {'L','C'}

>} sales)

sunny_talwar — Fri, 29 Jan 2016 18:03:06 GMT

Try one of these:

=Sum({<open_dt={">=$(vLastPeriod)"}, type = {'L','C'}>} sales)

=Sum({<open_dt={"$(='>=' & vLastPeriod)"}, type = {'L','C'}>} sales)

Anonymous — Fri, 29 Jan 2016 18:07:55 GMT

Thank you - that worked!

sunny_talwar — Fri, 29 Jan 2016 18:17:04 GMT

Great. Please close the thread by marking correct answer if you got what you were looking for