topic Re: First and Second Max string as a Filter in Triggers in QlikView

First and Second Max string as a Filter in Triggers

thimma_paul — Wed, 12 Aug 2015 05:48:12 GMT

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

Re: First and Second Max string as a Filter in Triggers

sunny_talwar — Wed, 12 Aug 2015 05:50:39 GMT

May be use this as the select in field trigger:

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

Re: First and Second Max string as a Filter in Triggers

thimma_paul — Wed, 12 Aug 2015 06:00:39 GMT

showing error

Re: First and Second Max string as a Filter in Triggers

sunny_talwar — Wed, 12 Aug 2015 06:02:33 GMT

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

Re: First and Second Max string as a Filter in Triggers

sunny_talwar — Wed, 12 Aug 2015 06:05:38 GMT

May be this:

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

Re: First and Second Max string as a Filter in Triggers

thimma_paul — Wed, 12 Aug 2015 06:24:29 GMT

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