topic Re: Is this Excel Calculation possible in Qlikview? in QlikView

Is this Excel Calculation possible in Qlikview?

jagan — Mon, 28 Apr 2014 06:28:28 GMT

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.

Re: Is this Excel Calculation possible in Qlikview?

tresB — Mon, 28 Apr 2014 06:56:27 GMT

Yes. Like attached sample.

Re: Is this Excel Calculation possible in Qlikview?

MK_QSL — Mon, 28 Apr 2014 07:21:42 GMT

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;

Re: Is this Excel Calculation possible in Qlikview?

anbu1984 — Mon, 28 Apr 2014 07:26:06 GMT

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;

Re: Is this Excel Calculation possible in Qlikview?

jagan — Mon, 28 Apr 2014 07:31:54 GMT

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.

Re: Re: Is this Excel Calculation possible in Qlikview?

tresB — Mon, 28 Apr 2014 07:47:46 GMT

Hi Jagan,

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

Re: Is this Excel Calculation possible in Qlikview?

jagan — Mon, 28 Apr 2014 09:04:52 GMT

Thanks Tresesco. Missed Total in the expression.

Regards,

Jagan.