topic GetFieldSelections() with result like vlookup in QlikView

GetFieldSelections() with result like vlookup

Anonymous — Tue, 13 Aug 2013 18:04:06 GMT

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

Gysbert_Wassenaar — Tue, 13 Aug 2013 18:09:38 GMT

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

Anonymous — Tue, 13 Aug 2013 18:19:58 GMT

Hi Gylbert!

It works perfect actually!

Thank you!

Regards,

Debora