Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi All,
Please help Me on this.
Thanks
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