Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thimma_paul
Contributor III
Contributor III

First and Second Max string as a Filter in Triggers

Hi All,

Data is below. I to apply as a trigger , first and second Highest Max string in an action to open a sheet. Can any one help on this.

 

2014-Q3
2014-Q4
2015-Q1
2015-Q2
2015-Q3
1 Solution

Accepted Solutions
thimma_paul
Contributor III
Contributor III
Author

tried with this

='(' & MaxString(YearQuarter) & '|' & left(MaxString(YearQuarter),6)&num(right(MaxString(YearQuarter),1)-1) & ')'

working fine now.

let me check with first sorted valeu

View solution in original post

5 Replies
sunny_talwar

May be use this as the select in field trigger:

='(' & MaxString(YearQuarter) & '|' & MaxString(YearQuarter, 2) & ')'

thimma_paul
Contributor III
Contributor III
Author

showing error

sunny_talwar

Would you be able to let us know what error message does it give you?

sunny_talwar

May be this:

='(' & FirstSortedValue(YearQuarter, -Num#(PurgeChar(YearQuarter, '-Q'), '##')) & '|' & FirstSortedValue(YearQuarter, -Num#(PurgeChar(YearQuarter, '-Q'), '##'), 2) & ')'

thimma_paul
Contributor III
Contributor III
Author

tried with this

='(' & MaxString(YearQuarter) & '|' & left(MaxString(YearQuarter),6)&num(right(MaxString(YearQuarter),1)-1) & ')'

working fine now.

let me check with first sorted valeu