variable value based on other variable

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I want to change the variable value based on the value change in another variable.

eg- I have conditional load-

if vSource = EMP then vFileName = Employee Data_12345.xlsx

if vSource = ORG then vFileName = Organisation Data_09876.xlsx

I want to put vFileName in the from statement, instead of hardcoding the filename.

Similarly the few FIELD NAMES in each source may change in future, so i want to put the field names of each excel source in variableS and show all variables in UI, so we can have a glance and if required change the field names in the variables. So the new set of field variables value should also be controlled based on value in vSource variable.

The attached app is about same above example.

Please help.

Re: variable value based on other variable

kaushiknsolanki — Sat, 17 Jun 2017 09:48:33 GMT

Hi,

You should use the value of the vFilename as below.

=If(vSource= 'ORG',' Employee Data_12345.xlsx','Organisation Data_09876.xlsx')

Regards,

Kaushik Solanki

topic variable value based on other variable in QlikView

variable value based on other variable

Re: variable value based on other variable