Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Variables Creation & Equation

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

2 Replies
Highlighted
Creator
Creator

Hi All,

Please help Me on this.

Thanks

Highlighted
Partner
Partner

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