topic Re: 2 Years Difference Graph in QlikView

2 Years Difference Graph

Mon, 28 Oct 2013 06:24:59 GMT

Which Graph We Can Use 2 years difference In Qlikview?

Re: 2 Years Difference Graph

Gysbert_Wassenaar — Mon, 28 Oct 2013 12:25:21 GMT

Bar chart, Line chart, Pie, Straight table, pivot table, Mekko chart, Block chart, Grid Chart, some gauge chart layouts.

Re: 2 Years Difference Graph

Mon, 28 Oct 2013 13:06:09 GMT

Any Example Mr.G Wassenaar ....!

Re: 2 Years Difference Graph

MayilVahanan — Mon, 28 Oct 2013 13:09:44 GMT

For better analysis,

Graphical Representation -> Bar or Line

Data Representation -> Straight or Pivot Charts

Re: 2 Years Difference Graph

Mon, 28 Oct 2013 13:12:24 GMT

Thank You Mayil Vahanan RamaSwamy

Re: 2 Years Difference Graph

Mon, 28 Oct 2013 13:14:10 GMT

Hi Nandha,

When you say, comparison, it should be BAR chart..As it years, you can use BAR chart.

Or if you want to show rolling Monthly differenace then you can use Line. If you want to show your values of target and Achived then you can use Combo chart

-Jay

Re: 2 Years Difference Graph

Mon, 28 Oct 2013 13:16:57 GMT

Yes Yes, I Got It Jaya Prai Thank For jaya praii and Mayil Vahanan Ramasamy....

Re: 2 Years Difference Graph

Mon, 28 Oct 2013 13:54:23 GMT

You can also use images like colored arrows or dots into a table or a text box to easily view the trend between the 2 years.

It goes like for instance :

If(($(InvoiceYTD)/Sum(Budget2013))<80, 'qmem://<bundled>/BuiltIn/led_r.png',

If(($(InvoiceYTD)/Sum(Budget2013))>=80, 'qmem://<bundled>/BuiltIn/led_g.png'))

Hope this help.