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

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

Thu, 02 Oct 2014 11:17:32 GMT

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

Thu, 02 Oct 2014 11:36:28 GMT

experts please help on that

datagrrl — Thu, 02 Oct 2014 12:12:07 GMT

Here is an answer for IFERROR

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 — Thu, 02 Oct 2014 12:21:10 GMT

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?

Thu, 02 Oct 2014 12:23:08 GMT

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

Wed, 08 Oct 2014 10:44:18 GMT

expersts please help.