Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Listing multiple expressions in a Search String

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.

1 Solution

Accepted Solutions
Highlighted
Master III
Master III

Re: Listing multiple expressions in a Search String

Hi Nate,

maybe Select in Field

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

Regards,

Antonio

View solution in original post

7 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Listing multiple expressions in a Search String

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Master III
Master III

Re: Listing multiple expressions in a Search String

Hi Nate,

maybe Select in Field

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

Regards,

Antonio

View solution in original post

Highlighted

Re: Listing multiple expressions in a Search String

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)

Highlighted
Master III
Master III

Re: Listing multiple expressions in a Search String

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

Highlighted
Contributor III
Contributor III

Re: Listing multiple expressions in a Search String

Perfect, thank you!

Highlighted
Contributor III
Contributor III

Re: Listing multiple expressions in a Search String

Thank you! Both of these worked as well.

Highlighted

Re: Listing multiple expressions in a Search String

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