topic Script Calculation in QlikView

Script Calculation

Fri, 22 May 2015 05:02:19 GMT

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.

Re: Script Calculation

senpradip007 — Fri, 22 May 2015 05:06:11 GMT

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

Re: Script Calculation

Fri, 22 May 2015 05:09:55 GMT

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.

Re: Script Calculation

Fri, 22 May 2015 05:12:25 GMT

Ok Now please find the attached xls.

Re: Script Calculation

Fri, 22 May 2015 05:19:27 GMT

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

Re: Script Calculation

Fri, 22 May 2015 05:24:59 GMT

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.