Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

GetFieldSelections() with result like vlookup

Hi,

I have a scenery that I have month with a different dispose of the normal.

I have one table from excel and one table inline (with two columns: Month and Month Name).

I want to get the selection from Month Name and use the respective value of Month.

The GetFieldSelections() just works if I click directly over the field "Month".

The example is in attachment.

How could I make this?

Thanks!

Regards,

Debora

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try =sum($(='[Month ' & Month_test & ']')). See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try =sum($(='[Month ' & Month_test & ']')). See attached qvw.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Hi Gylbert!

It works perfect actually!

Thank you!

Regards,

Debora