Is this Excel Calculation possible in Qlikview?

[jagan]

Hi Friends,

I have to do one calculation in Qlikview which is done in Excel, need to replicate the same calculation in Qlikview.  Please refer the attached excel file and refer column C for the formulae.  I tried using Below(), but now working as expected. 

Thanks for your suggestions in advance.

Regards,

Jagan.

[tresesco]

Yes. Like attached sample.

[MK_QSL]

T1:

Load *, RowNo() as NO Inline [

Group, Sales

1, 100

2, 150

3, 200

4, 100

];

Join

Load NO,

  IF(RowNO() = 1, 0, RangeSum(Peek(CalcValue),-Previous(Sales))) as CalcValue

Resident T1

Order By NO desc;

[anbu1984]

Temp:

LOAD Group,

     Sales   

FROM

[Test Values.xlsx]

(ooxml, embedded labels);

Result:

LOAD *

  , if(RowNo()=1, 0,Peek(Calc)-Previous(Sales)) as Calc

Resident Temp

Order by Group desc;

drop table Temp;

[jagan]

Hi Tresesco,

I applied the same logic in my Dashboard the values are not matching with the Qlikview expression and Excel Calculation.

Please find the attached updated Excel file , need to do the same calculation in Column D of excel file in Qlikview.

Regards,

Jagan.

[tresesco · Accepted solution]

Hi Jagan,

Probably you are missing TOTAL keyword. Please find here your expected output attached

[jagan]

Thanks Tresesco.  Missed Total in the expression.

Regards,

Jagan.