i have some calculation in excel i want implement same calucaltion in qlikview pivot or chart table?

[#1]

i have some calculated data in excel i want to implement same in qlikview ?

please find attached excel sheet contains two tabs base data and calc data

calc tab  contain some calculations are there i want to show same output in qlikview by using pivot or straigh table

common column in both the sheets DCC column

excel qlikview out put contains some forulas if u click qlikview out put cells u can find those formulas like

=IFERROR(VLOOKUP($A9,'Base Data'!$A:$C,2,0),0)

=SUMIFS(L:L,$B:$B,$A10)

=IF($D9="Internal",(J9+K9)*$C9,0)

i want to implement same formulas in qlikview please help on those formulas

please help on that

thanks

[#2]

experts please help on that

[datagrrl]

Here is an answer for IFERROR

http://community.qlik.com/thread/93960

Basically use the ALT function

For =IF($D9="Internal",(J9+K9)*$C9,0)

I assume this would work

IF(Dimension1='Internal',(Measure1+Measure2)*Measure3,0)

[ThornOfCrowns]

is this the same set of data that you mention in http://community.qlik.com/thread/135438?

If so, can you please keep everything in one thread?

[#5]

Hi

thanks for replying

can u explain briefly   below formulas in excel file

=SUMIFS(L:L,$B:$B,$A10)

=IF($D10="Internal",(J10+K10)*$C10,0)

Thanks

[#6]

expersts please help.