topic Re: Dividing two values from the same column or values which are not appearing in one row in QlikView

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

muhammadraza — Thu, 19 Dec 2013 08:38:29 GMT

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

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

Thu, 19 Dec 2013 08:50:10 GMT

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

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

sujeetsingh — Thu, 19 Dec 2013 08:54:08 GMT

Try to implement it in the UI not in the Script

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

danieloberbilli — Thu, 19 Dec 2013 09:09:16 GMT

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) ;

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

rohit214 — Thu, 19 Dec 2013 09:39:18 GMT

Dear Raza,

PFA hope it helps you

Regards

Rohit