topic Re: Field Values As Variables in QlikView

Field Values As Variables

ajithsachin — Tue, 27 Nov 2012 13:07:40 GMT

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..

Re: Field Values As Variables

fosuzuki — Tue, 27 Nov 2012 21:05:13 GMT

Hi, check the attached sample...

Re: Field Values As Variables

ajithsachin — Wed, 28 Nov 2012 05:37:08 GMT

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..

Re: Field Values As Variables

fosuzuki — Wed, 28 Nov 2012 11:12:23 GMT

No, you can't...

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

Re: Field Values As Variables

ajithsachin — Wed, 28 Nov 2012 11:34:20 GMT

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..?

Re: Field Values As Variables

fosuzuki — Sat, 01 Dec 2012 20:26:46 GMT

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...