Dividing two values from the same column or values which are not appearing in one row

[muhammadraza]

Hello,

I have a straight table (please see attached), I want to create a third column (as indicated in the attached document) by dividing two values appearing in the same column or which are (also) appearing into two separate columns but which are not in one row, plz suggest how can I achieve this thing in Qlikview.

Best Regards,

Muhammad Raza

[#2]

Hi Muhammad,

If your values are stored in separate fields (like totalvalue, incomevalue) just remove your column type

you'll then get total and income as 2 expressions based on the same dimension

you can divide them

If there are stored under one field (like value) based on Type dimension then use "above" function (or above(above(...) if not sorted)

best regards

chris

[sujeetsingh]

Try to implement it in the UI not in the Script

[danieloberbilli]

Please find attached as possible solution.

Directory;

LOAD Date,

     Points,

     num((Points / Previous(Points))-1,'##%')  as Increase

FROM

Mappe21.xlsx

(ooxml, embedded labels, table is Tabelle1) ;

[rohit214 · Accepted solution]

Dear Raza,

PFA hope it helps you

Regards

Rohit