Field Values As Variables

[ajithsachin]

Hi..

     I have a load statement

     LOAD * INLINE [

         variable_name

         var_first

         var_second

         var_third

     ];

     i have created the three variables in qlikview application with value 1,2,3 respectively.

     i want to display all the variables value in a pivot table.Variable names i will get from the field 'variable_name'

     i want to convert the fields as variables value.

     Can anybody help please..

[fosuzuki]

Hi, check the attached sample...

[ajithsachin]

Thanks Fernando..

Is it possible to show the values of variables from the filed 'variable'.so that i can load n number of variables with out changing the expression in the design part..

[fosuzuki]

No, you can't...

Maybe you can use Inputfields instead of variables... What is your requirement?

[ajithsachin]

i am creating a qv document for Return Of Investment kind of project.

in that around 60 variables are there , that user can change from front end.

in this case i have to create the inputfield manualy around 60 tmes.

is there any other way to do that..?

[fosuzuki]

I don't understand when you state: "I have to create the inputfield manually around 60 times"... I think it is possible to do it in both ways: variables and inputfields. Either way, you will have to manually create all the 60 variables or inputfields...