Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

2 Replies
its_anandrjs

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

Not applicable
Author

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