topic Re: calculate DIF between tow rows in QlikView

calculate DIF between tow rows

anatle1234 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have this table:

the last row is the difference between the third and first rows.

what do I put in the expression in order to show difference?>

thanks,

Anat

Re: calculate DIF between tow rows

mdmukramali — Sun, 17 Dec 2017 11:24:41 GMT

Hi,

Can you attach Sample Data.

Re: calculate DIF between tow rows

Anil_Babu_Samineni — Sun, 17 Dec 2017 11:39:31 GMT

Thus Plan\Target PTDS and Actual - Completed are under field??

Re: calculate DIF between tow rows

anatle1234 — Sun, 17 Dec 2017 11:51:54 GMT

hi,

I defined those fields like this in the transform script:

left join (Table)
load order_id,
if(Indicator='Indication','Plan_Target_PTDs',
if(Indicator<>'Indication' and project_status='In progress','In_progress_PTD',
if(Indicator<>'Indication' and project_status='completed','Actual_completed')))
as order_status_PTD
Resident Table;

the order_status_PTD , is the calculated field for Plan/Target PTD etc... those are Dates, and we group orders by those Dates.

Re: calculate DIF between tow rows

Anil_Babu_Samineni — Sun, 17 Dec 2017 11:54:47 GMT

Would you mind, Can you attach application to test?

Re: calculate DIF between tow rows

anatle1234 — Sun, 17 Dec 2017 13:03:32 GMT

please see the excel and the model. I need the difference between row 1 and row3 in the model.

Re: calculate DIF between tow rows

Anil_Babu_Samineni — Sun, 17 Dec 2017 14:27:09 GMT

PFA

Re: calculate DIF between tow rows

Anonymous — Mon, 18 Dec 2017 09:56:45 GMT

Thank you Anil,

I am working with Anat and we need help with that also:

Actual vs Planned displays gaps with the following color indication:
- Red for negative gap.
- Green for positive or zero gap.

Limor

Re: calculate DIF between tow rows

Anil_Babu_Samineni — Mon, 18 Dec 2017 13:38:10 GMT

Perhaps this?

Don't duplicate for single issue - Re: % Prediction Accurancy