topic Greater than or equal to a variable (set analysis) in QlikView

Greater than or equal to a variable (set analysis)

Thu, 19 Jul 2012 20:25:36 GMT

Hello,

I am trying to find the set analysis that will only produce a value when a date field is greater to or equal to a variable I have set. I know how to make it equal to a variable however that is the extend of my knowledge. Here is what I have so far

Only({$<DateField={'$(variable)'}>} Name)

Is there a way to make the set only look at values greater to or equal to the variable.

Thank You!

Re: Greater than or equal to a variable (set analysis)

pbaenen — Thu, 19 Jul 2012 20:42:33 GMT

Try this:

Only({$<DateField={">=$(=$(variable))"}>} Name)

Re: Greater than or equal to a variable (set analysis)

MayilVahanan — Thu, 19 Jul 2012 20:43:43 GMT

Hi,

Try like this,

=Concat({<DateField = {'>=$(variable)'}>}Distinct Name,',')

If you use only here, you will get null value, because, if only one value is occur only produce result..

Hope it helps

Re: Greater than or equal to a variable (set analysis)

Wed, 21 Oct 2015 12:50:59 GMT

Thanks! That solution worked perfect for me.