Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Default value as null when there is no selections made.

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

17 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

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

Not applicable
Author

@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
Not applicable
Author

Try this :

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

See the attached Application.

Not applicable
Author

try this:

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

See the attached application.

Not applicable
Author

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

Not applicable
Author

in the Expression Tab:

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

Not applicable
Author

Hey Erika Sorry yaar, its not working.

Did you got my problem correctly.

Regards

Sagar Gupta

Not applicable
Author

Hey Erika Sorry yaar, its not working.

Did you get my problem correctly.

Regards

Sagar Gupta

Not applicable
Author

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.