Variables Creation & Equation

[chandra63]

Hi ,

Hope All Doing Good.

We  have to create the Customer Behavior Report which is in  excel file in the sheet score_of_sample by the reference of attached word file.

we struck at point 7 in the Word File.

Please guide me on this.Its help us a lot .

I have tried a lot, but possibly not everything. Maybe some of you guys might be able to come up with a suitable solution.

please refer the QVW file

Thanks & Regards.

Chandra

[chandra63]

Hi All,

Please help Me on this.

Thanks

[andrei_delta]

hi,

make an excel document with the next columns Variable | Formula.

The column Variable will contain the name for you variable

The column Formula will contain the formula you want to store ( for example Sum(X))

formulas:

load

Variable ,

Formula,

from EXCEL FILE;

for i=0 to NoOfRows('formulas')-1

let var=peek('Variable',$(i),'formulas');

let $(var)=peek('Formula',$(i),'formulas');

next;

the variables will be generated in qlik with the formulas you defined in excel

hope it helps,

Andrei