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: 
surajap123
Creator II
Creator II

variable value based on other variable

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.

1 Reply
kaushiknsolanki

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".