Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Perhaps the approach mentioned here can help you.
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
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
Perhaps the approach mentioned here can help you.