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

[#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

please help on that

thanks

[#2]

Any one please help on  that..

[#3]

Any one please help on t

[phaneendra_kunc]

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.

[#5]

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

[aveeeeeee7en]

Hi

Use Pivot Table for your requirement.

See the Snapshot:

Also, see the Attachment.

Regards

Av7eN

[#7]

here implementing the same excel formulas in qlikview  is bigissue

[#8]

any body help on that

[#9]

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.

[#10]

Any experts can help on that please

Thanks