topic Re: variable time range in QlikView

variable time range

Wed, 25 Nov 2020 16:16:04 GMT

Hello!

I need to include in a analisys set, a variable range running from 2010 until the term is applied (Not today ())

That is, if I make a calculation for 2013 that would range from 2010 to 2013 and if it did in 2016 would range from 2010 to 2016

count ({<SET ANALISYS>} if (Reactivation = 'YES', NumeroDeAfiliado))

Thank you very much!!

sunny_talwar — Wed, 12 Oct 2016 20:29:41 GMT

If you make calculation? How do you make calculations here? Do you mean make selection in year field?

May be this:

Count({<Year = {'>=2010<=$(=Max(Year))'}, Reactivation = {'YES'}>} NumeroDeAfiliado)

vinieme12 — Wed, 12 Oct 2016 20:33:34 GMT

count ({<YEAR = {">=2010&<=$(vYearSelection)"}>} if (Reactivation = 'YES', NumeroDeAfiliado))

where variable

vYearSelection = getfieldselection(YEARFIELD)

Wed, 12 Oct 2016 20:48:40 GMT

hi! Thank you Vineeth!

As I create "vYearSelection" variable in the script?

don`t take that as a function.

sunny_talwar — Wed, 12 Oct 2016 21:00:50 GMT

You want to create it in script?

Thu, 13 Oct 2016 12:26:09 GMT

Yes, just the variable 'vYearSelection'

sunny_talwar — Thu, 13 Oct 2016 17:00:23 GMT

Then how will this be dynamic? I am missing something here?

What did you mean here:

"if I make a calculation for 2013 that would range from 2010 to 2013 and if it did in 2016 would range from 2010 to 2016"

vinieme12 — Fri, 14 Oct 2016 06:02:52 GMT

SET vYearSelection = getfieldselections(YEARFIELD);