Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

RelativyeMonthID to display the Month name

Hello,

Im new to qlikview and I am having the following problem....

I have 2 tables (RelativeMonthID and MonthYear)

Capture.PNG

And I want a textbox to show the Min MonthYear (which must be based on the RelativeMonthID ) when I select from Ene to May.

Can you help me please??

Thank you.

1 Solution

Accepted Solutions
Not applicable
Author

Hi Iuri,

Try it:

=Only({$<RelativeMonthID={'$(=Min(RelativeMonthID))'}>} MonthYear)

Jean Filipe Delle

View solution in original post

2 Replies
Not applicable
Author

Hi Iuri,

Try it:

=Only({$<RelativeMonthID={'$(=Min(RelativeMonthID))'}>} MonthYear)

Jean Filipe Delle

Not applicable
Author

Thank you so much mate (:

It work