Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
anatle1234
New Contributor III

calculate DIF between tow rows

Hi,

I have this table:

Capture.PNG

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

Tags (1)
8 Replies
mdmukramali
Valued Contributor III

Re: calculate DIF between tow rows

Hi,

Can you attach Sample Data.

Re: calculate DIF between tow rows

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
anatle1234
New Contributor III

Re: calculate DIF between tow rows

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

Would you mind, Can you attach application to test?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
anatle1234
New Contributor III

Re: calculate DIF between tow rows

Hi

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

PFA

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
limordah
New Contributor

Re: calculate DIF between tow rows

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

Perhaps this?

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

Capture.JPG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)