Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
balasundaram
Creator II
Creator II

fiscal year not working in open triger...?

i have filed like

FiscalYear

2013-2014

2014-2015

i written condition in trigger

Doccument Trigger:

OnOpen->select in field action-->

filed: FiscalYear

search string: =Max(FiscalYear)

but not working...

1 Solution

Accepted Solutions
colin_albert

max() selects the maximum numeric value, maxstring() selects the maximum text value.

Your fiscal year is defined as '2013-2014' so is a text value, therefore you will need to use maxstring(FiscalYear).

Another option is to define the financial year as a dual field, then max() will work.

View solution in original post

5 Replies
Not applicable

try this

=maxstring(FiscalYear)

tresesco
MVP
MVP

Check the output of Max(FiscalYear) in a textbox. That is possibly not generating a similar to FiscalYear format output. It could give you a single year like 2014 or 2015. Therefore,the search string could possibly not matching with field value and your trigger doesn't work properly. Share your sample qvw to be helped specifically.

aveeeeeee7en
Specialist III
Specialist III

Hi

Create a new field in Backend Script. Like this

Purgechar(FiscalYear,'-') AS New_FiscalYear

After Reload use this field in Trigger.

Create Trigger > Select in Field: New_FiscalYear > Search String: Max(New_FiscalYear)

It will give you the Max Fiscal Year.

Regards

Av7eN

colin_albert

max() selects the maximum numeric value, maxstring() selects the maximum text value.

Your fiscal year is defined as '2013-2014' so is a text value, therefore you will need to use maxstring(FiscalYear).

Another option is to define the financial year as a dual field, then max() will work.

View solution in original post

balasundaram
Creator II
Creator II
Author

thank you..