Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
zakpullen
Contributor III
Contributor III

Finding FieldValue from a specific table in script

Hi,

Is there  a way to specifiy the table the field value should be returned from? This line is from a master calendar.

Max(FieldValue('PeriodDate', RecNo())) as MaxDate

Many thanks

Labels (1)
1 Solution

Accepted Solutions
rubenmarin

Hi, FildValue() uses all values of the field, witout specifying the table. In the table you want to retrieve values you can add a field like "PeriodDate as PeriodDateCalendar" and use this field to iterato through it's values.

Also you can do a resident load but it will be slower if the table has many records.

View solution in original post

3 Replies
rubenmarin

Hi, FildValue() uses all values of the field, witout specifying the table. In the table you want to retrieve values you can add a field like "PeriodDate as PeriodDateCalendar" and use this field to iterato through it's values.

Also you can do a resident load but it will be slower if the table has many records.

mikemiler
Contributor III
Contributor III

Putting out gated content is wise if you’ve already built a library of content that you are sure your audience is enjoying. This way, loyal readers won’t be apprehensive in giving you their names and email addresses to read what you wrote in https://folderly.com/email-warmup.

zakpullen
Contributor III
Contributor III
Author

Thank you!