topic Re: Variables Creation & Equation in QlikView

Variables Creation & Equation

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

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 — Wed, 07 Nov 2018 05:43:24 GMT

Hi All,

Please help Me on this.

Thanks

andrei_delta — Wed, 07 Nov 2018 14:33:42 GMT

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