Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Jagan,
Probably you are missing TOTAL keyword. Please find here your expected output attached
Yes. Like attached sample.
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;
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;
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.
Hi Jagan,
Probably you are missing TOTAL keyword. Please find here your expected output attached
Thanks Tresesco. Missed Total in the expression.
Regards,
Jagan.