How to show difference between rows

[#1]

Dear fellow experts,

I have a table like this which is loaded in the script

Field                         Location          YTD     Month     Budget

Turnover                    Japan               100     20               110

Gross margin             Japan                 40     10               50

Operating profit          Japan                 10     2                 20            

Turnover                    India                1000     500               1100

Gross margin             India                 600         200               750

Operating profit          India                    300     100               350

I will like to show operating expense as difference between Operating profit and gross margin in a straight table.

Is this possible? Bearing in mind that my table is pretty huge with a few hundred rows as there are more than 2 locations as in the example above.

[sujeetsingh]

You need to convert the rows as column and columns as row using the Generic load/cross table .

Search for these ins reference manual.

[#3]

Hi Sujeet,

Many thanks for the reply. At least i know it could be done.

As i am relatively new to Qlikview, can you please guide me as to where exactly i could download the correct reference manual?