topic Re: Listing multiple expressions in a Search String in QlikView

Listing multiple expressions in a Search String

dukane24 — Wed, 09 Aug 2017 18:10:54 GMT

I'm trying to create a button action that will select the five latest dates loaded, using:

Max(DateField)

Max(DateField,2)

Max(DateField,3)

Max(DateField,4)

Max(DateField,5)

I know that in the Search String I can list out items like this: ("Date1"|"Date2"|"Date3"|"Date4"|"Date5")...

But what I'd like to do is list out the five expressions like this instead, and I haven't been able to get the syntax figured out. I know that I can make five separate select actions, but I would really like to get them into one. Is there a way to do this? I appreciate your help.

Re: Listing multiple expressions in a Search String

kaushiknsolanki — Wed, 09 Aug 2017 18:13:34 GMT

Hi,

Not sure but you can try this,

='("'& Max(DateField) &'"|"'& Max(DateField,2) &'"|"'& Max(DateField,3)&'"|"'& Max(DateField,4)&'"|"'& Max(DateField,5)&'")'

Regards,

Kaushik Solanki

Re: Listing multiple expressions in a Search String

antoniotiman — Wed, 09 Aug 2017 18:17:58 GMT

Hi Nate,

maybe Select in Field

='>='&Max(DateField,5)

Regards,

Antonio

Re: Listing multiple expressions in a Search String

sunny_talwar — Wed, 09 Aug 2017 18:20:10 GMT

Might make sense to add {1} in set analysis

='>=' & Max({1} DateField, 5)

Or if selections needs to be honored, then this

='>=' & Max(DateField, 5) & '<=' & Max(DateField)

Re: Listing multiple expressions in a Search String

antoniotiman — Wed, 09 Aug 2017 18:29:18 GMT

Hi think not needed because <=Max(Field) Always verified. however they don't hurt.

Re: Listing multiple expressions in a Search String

dukane24 — Wed, 09 Aug 2017 18:33:51 GMT

Perfect, thank you!

Re: Listing multiple expressions in a Search String

dukane24 — Wed, 09 Aug 2017 18:34:35 GMT

Thank you! Both of these worked as well.

Re: Listing multiple expressions in a Search String

sunny_talwar — Wed, 09 Aug 2017 18:36:15 GMT

Are you going to be using this without any selection being made? Or is this can be based on selection made....?