topic Re: Help required to evaluate if attached excel data structure can be created in Qlikview in QlikView

Help required to evaluate if attached excel data structure can be created in Qlikview

Tue, 02 Apr 2013 09:54:27 GMT

Hello,

I am trying to replicate one of my existing excel template into Qlikview.

I have attached the excel template for your reference. Please refer to tab "PL01C-BAL1" and look for formulas only as i have not update the data for now.

In the excel template I have a financial hirearchy.

for example :

Revenue XXX

Less COS -XXX

= Gross Profit XXX

Less Opex Exp -XXX

= Operating Profit XXX

In between each of these data points i have to calculated few metrics like Gross Profit%, Opex Exp% etc.

How do I create similar to the Excel view in Qlikview. I belive straight Table or Pivot can not be used solely, but need some script to be written within these Objects to show the metrics calculation like Gross Profit% etc.

Kindly request you to help me with your suggestions.

Thanks,

Vinayaka

Re: Help required to evaluate if attached excel data structure can be created in Qlikview

kaushiknsolanki — Tue, 02 Apr 2013 10:13:17 GMT

HI,

I am not sure whether its possible or not, but I am here by attaching few document which may help you.

In Data Visualization App, there is a example for butterfly chart.

Regards,

Kaushik Solanki

Re: Help required to evaluate if attached excel data structure can be created in Qlikview

Tue, 02 Apr 2013 11:28:27 GMT

Thanks for the data. But I am looking for representing the data in a Vertical form.

In the qvw file that you sent, Straight Table and Pivot is used to represent the same in Horizontal form.

Please let me know if you have any suggestions to represent the data in Vertical form.

Thanks,

Vinayaka

Re: Help required to evaluate if attached excel data structure can be created in Qlikview

Gysbert_Wassenaar — Tue, 02 Apr 2013 12:13:38 GMT

Perhaps the approach mentioned here can help you.