2 Years Difference Graph

[#1]

Which Graph We Can Use 2 years difference In Qlikview?

[Gysbert_Wassenaar]

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

[#3]

Any Example Mr.G Wassenaar ....!

[MayilVahanan]

Hi

For better analysis,

Graphical Representation -> Bar or Line

Data Representation -> Straight or Pivot Charts

[#5]

Thank You Mayil Vahanan RamaSwamy

[#6]

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

[#7]

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

[#8]

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.