Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Greater than or equal to a variable (set analysis)

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!

Tags (2)
3 Replies
pbaenen
New Contributor III

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

Try this:

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

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

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

Not applicable

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

Thanks! That solution worked perfect for me.

Community Browser