Gauge Chart - No Data to display

[#1]

I have a gauge chart that works as intended with one exception.  The gauge shows a percentage change between two years.  If I have no years selected, the gauge completely disappears and just leaves a message of "No Data to display" (not what I want).  How do I get the gauge chart to remain even if no years are selected (I am not terribly concerned about the value it shows.  I just want the user to know the chart is there by seeing it)?

[its_anandrjs]

I believe you use variables in the guage expression if so then in place of variable use SET analysis or please provide expression.

[MK_QSL]

Use expression as below

Just an example below

(SUM({<Year = {'$(=Max(Year))'}>}Sales) - SUM({<Year = {'$(=Max(Year)-1)'}>}Sales))/SUM({<Year = {'$(=Max(Year)-1)'}>}Sales)

[#4]

That's the way I had it to begin with and it still shows no gauge unless year(s) are selected.  I tried simply initializing the variables but all that did was change the definition of my variable to  whatever I SET or LET it to.

[MK_QSL]

Check enclosed file....

[#6]

Manish,

There was nothing attached.

Alex

[MK_QSL]

It is there

[#8]

Manish,

I get a messge when I try to open it that says that since I am a personal user if I open it I cannot open future documents.  Not sure I want to do that.  Any other ideas?

[#9]

Hi Alexander,

  you are using personal edition that's why you can't access the application,can you please share the what ever the

expressions you are using in gauge chart or test application with your expressions.

Thanks

Basha

[MK_QSL]

Use below script

=============

Load * Inline

[

  Year, Sales

  2011, 200

  2012, 220

  2013, 300

  2014, 500

];

==============

Create a Guage Chart

Dimension

No Dimension

Expression

(SUM({<Year = {'$(=Max(Year))'}>}Sales)-SUM({<Year = {'$(=Max(Year)-1)'}>}Sales))/SUM({<Year = {'$(=Max(Year)-1)'}>}Sales)

Hope this helps...