Script Calculation

[#1]

Hi,

I have an xls file, where entire calculation has been done by column to column or one sheet to another. Now I have to calculate à Net SCR - Column (V).

There is one sheet for SRD PSI à Column Name (SPD > Repl - U)

I have to calculate the same filed by using another sheet SPD PSI à From Column Name

(SPD>SRD Repl. – S).

Then Only I can assign the value in Net SCR by using Column Name (SPD > Repl - U). I have to use the same code in script level.

How I can do the same in QlikView.

For ref. please find the attached xls.

Thanks.

[senpradip007]

Your file is showing something wrong. Please upload a fresh one.

[#3]

Hi,

I have an xls file, where entire calculation has been done by column to column or one sheet to another. Now I have to calculate à Net SCR - Column (V).

There is one sheet for Sheet 1 Column Name (SPD > Repl - U)

I have to calculate the same filed by using another sheet Sheet 2 From Column Name

(SPD>SRD Repl. – S).

Then Only I can assign the value in Net SCR by using Column Name (SPD > Repl - U). I have to use the same code in script level.

How I can do the same in QlikView.

For ref. please find the attached xls.

Thanks.

[#4]

Ok Now please find the attached xls.

[#5]

Things are still not clear. Load the STOCK file with Sheet1 data and then with Sheet2 data. They will join based on the Model field (remember the Model field name used be same in both sheets - same case)

And then you can use columns to do calculations.

Hope this is helpful.

Thanks,

Singh

[#6]

I Don't have to join both sheet. Keep the separate sheet and link with SKU Model and (Channel Code and SPD Code are same in both sheet) and then start the calculation from Stock norm to Net NCR.

Thanks for reply.