Default value as null when there is no selections made.

[#1]

Hi,

I have a doubt, when i made gauge and test tubes in my view m getting default values as the minimum values in that particular column. I need these gauge and tubes to display null value whenever there is no selections made.

For eg: I have a column with marketshare(4(min)------96(max)) and i represented the values in testtube. My dimenssion and Expression is same(Market Share).  Now without any selection, testtube is showing 4 as default.

Thanks in advance

Regards

Sagar

[CELAMBARASAN]

Hi,

     Null means you don't want to display the graphics instead a message?if so

     Go to chart properties-->General tab-->set Calculation Condition as if(GetSelectedCount(FieldName),0,1)

Celambarasan

[#3]

@Celambarasan

Thanks for your reply.

But what i meant is: if i m not selecting any feilds, i should see my testtube blank. I also tried your answer but its not working.

Regards

Sagar

[Anonymous]

Try this :

=if(isnull(getcurrentselection()),0,<Expression>)

See the attached Application.

[#5]

try this:

=if(isnull(getcurrentselection()),0,<Expression>)

See the attached application.

[#6]

Thanks a lot Erika

Where should i give this condition, and will the <Expression> same as I have used in Expression tab.

Regards

Sagar Gupta

[#7]

in the Expression Tab:

=if(isnull(getcurrentselection()),0,Sum(Sales))

[#8]

Hey Erika Sorry yaar, its not working.

Did you got my problem correctly.

Regards

Sagar Gupta

[#9]

Hey Erika Sorry yaar, its not working.

Did you get my problem correctly.

Regards

Sagar Gupta

[#10]

have u seen the attached application also....

Can u plz explain wht u want....

The expression which i hv written will work like:

if no selections are being done then Testube will be blank....

when the selection are there then data will be filled according to th selections.

What have u Given in Min And Max Condition.