topic Re: i have some calculated data in excel i want to implement same in qlikview ? in QlikView

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

Mon, 29 Sep 2014 16:10:37 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

please help on that

thanks

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

Mon, 29 Sep 2014 16:52:23 GMT

Any one please help on that..

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

Tue, 30 Sep 2014 05:31:59 GMT

Any one please help on t

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

phaneendra_kunc — Tue, 30 Sep 2014 05:44:38 GMT

I really don't understand what your issue is?

in your base data i see DCC as a column and January and February as facts. not sure how you got ICC, Cost & Inter in your Cal tab.

Can you elaborate what you are trying to achieve.

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

Tue, 30 Sep 2014 06:25:48 GMT

by using base data file and table 2 data i want show calculated data out put in pivot table

in calulated data contain excel formulas

i want to implement same formulas in qlikview

please help on that

i added new attachement

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

aveeeeeee7en — Tue, 30 Sep 2014 06:28:27 GMT

Use Pivot Table for your requirement.

See the Snapshot:

Also, see the Attachment.

Regards

Av7eN

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

Tue, 30 Sep 2014 06:41:34 GMT

here implementing the same excel formulas in qlikview is bigissue

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

Tue, 30 Sep 2014 09:16:02 GMT

any body help on that

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

Tue, 30 Sep 2014 09:36:01 GMT

For the Vlookup use ApplyMap and for the rest of calculated if condition fields, you can use if conditions in Qlikview.

Refer to Qlikview manual on how to for the ApplyMap and If conditions.

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

Tue, 30 Sep 2014 15:06:47 GMT

Any experts can help on that please

Thanks

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

MarcoWedel — Tue, 30 Sep 2014 15:38:52 GMT

please post your current application version to see which part is still missing.

thanks

regards

Marco

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

Tue, 30 Sep 2014 16:09:54 GMT

how to right excel vlookup formula in qlikview script

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

MarcoWedel — Tue, 30 Sep 2014 19:26:58 GMT

Hi,

like Eddie Morah already suggested, you might use the ApplyMap() function:

mapBaseData:
Mapping
LOAD DCC,
    January
FROM [http://community.qlik.com/servlet/JiveServlet/download/621476-129488/Sample%20Data.xlsx] (ooxml, embedded labels, table is [Base Data]);

tabInput:
LOAD DCC,
    ICC,
    cost,
    Inter,
    ApplyMap('mapBaseData', DCC) as Expe
FROM [http://community.qlik.com/servlet/JiveServlet/download/621476-129488/Sample%20Data.xlsx] (ooxml, embedded labels, header is 2 lines, table is Calc);

hope this helps

regards

Marco

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

Wed, 01 Oct 2014 09:25:16 GMT

what about excel formulas

that is excel out put simply u load in chart

i want qlikview calucalted data

in excel ile u can find qlikview out put values

in in side if u click any sell u can see excel formulas i want implememt same logic in qlikview

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

MarcoWedel — Wed, 01 Oct 2014 10:46:57 GMT

Maybe I didn't explain enough, let me try again.

In the script, I posted before, I used a mapping load to create a map of your excel lookup table (sheet "Base Data").

I then used the applymap function to lookup the DCC value in this mapping table during the load of your data table (sheet "Calc") and loaded the corresponding January value as a new field "Expe", just like your vlookup function does in Excel.

So it's not just the Expe column loaded from your Excel source, like you suggested.

hope this helps

regards

Marco

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

Wed, 01 Oct 2014 11:35:47 GMT

if u click inta in and intra out columns excel file

u can find below formulas

=SUMIFS(J:J,$B:$B,$A7)

=IF($D7="Internal",(H7+I7)*$C7,0)

how to implement above foumulas in qlikview pivoit table or script

please help on that

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

Wed, 01 Oct 2014 15:29:26 GMT

any one

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

MarcoWedel — Wed, 01 Oct 2014 15:41:33 GMT

did you successfully try the applymap approach for the Expe field?