topic Set 1 or 0 to variable if selected field is on a specific table in QlikView

Set 1 or 0 to variable if selected field is on a specific table

Wed, 10 Aug 2011 12:28:39 GMT

Hello,

is it possible to set a variable with the result 1 or 0 if selected(s) field(s) is(are) on a specific table?

I have 3 tables (Table_NAV; Funds;Memory) and a reference date set by a variable (vDateRef)

Table_NAV	Funds	Memory
Date	Funds_Nbr	Contract_Nbr
Funds_Nbr	Type	Funds_Nbr
NAV	Name	Date
	ISIN	Units
	StartDate

The 2 first have date all days. Last one only endmonth.

Wath I want is use the vDateRef if selected Fields are on table "Table_NAV" or "Funds" otherwise a endmonth date if selected fields are on table "Memory".

thanks for your help.

Laurent

Set 1 or 0 to variable if selected field is on a specific table

its_anandrjs — Wed, 10 Aug 2011 12:52:02 GMT

Hi,

You need to use Getfieldselections() function to fetch the value of the filelds and match the values according to that you check the fields and set value of variable.

Regards,

Anand

Set 1 or 0 to variable if selected field is on a specific table

Mon, 22 Aug 2011 15:28:13 GMT

Hello Anand,

Thanks for your suggestion.

Unfortunatly, that doesn't help me for this. If there was the same function but with the table it could. What I was trying to do was affect a value to a variable if a field is selected in a defined table (regardless of the field) and an other value if its a selected field from an other table.

But your suggestion have help me for other expression.

Regards

Laurent