topic Re: Default value as null when there is no selections made. in QlikView

Default value as null when there is no selections made.

Wed, 21 Mar 2012 09:28:51 GMT

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

Default value as null when there is no selections made.

CELAMBARASAN — Wed, 21 Mar 2012 10:05:52 GMT

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

Default value as null when there is no selections made.

Wed, 21 Mar 2012 11:29:11 GMT

@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

Re: Default value as null when there is no selections made.

Anonymous — Wed, 21 Mar 2012 11:57:56 GMT

Try this :

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

See the attached Application.

Re: Default value as null when there is no selections made.

Wed, 21 Mar 2012 12:06:45 GMT

try this:

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

See the attached application.

Default value as null when there is no selections made.

Wed, 21 Mar 2012 12:09:45 GMT

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

Default value as null when there is no selections made.

Wed, 21 Mar 2012 12:13:46 GMT

in the Expression Tab:

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

Default value as null when there is no selections made.

Wed, 21 Mar 2012 12:20:17 GMT

Hey Erika Sorry yaar, its not working.

Did you got my problem correctly.

Regards

Sagar Gupta

Re: Default value as null when there is no selections made.

Wed, 21 Mar 2012 12:21:15 GMT

Hey Erika Sorry yaar, its not working.

Did you get my problem correctly.

Regards

Sagar Gupta

Default value as null when there is no selections made.

Thu, 22 Mar 2012 04:29:01 GMT

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.

Default value as null when there is no selections made.

Thu, 22 Mar 2012 06:46:04 GMT

Thanks for your reply.

I tried and its not working,now let me explain the whole problem.

I have a view and it have(2 testtubes, 3 digital display, 2 thermometer, 2 Guages). I have two multiboxes(where i apply my filters) and two listboxes(which are my real selections to get the result). Now my problem is whenever i apply my all filters I see my testtube and digital display showing numbers(which i don't want at all).

I only want my charts(2 testtubes, 3 digital display, 2 thermometer, 2 Guages) to display values, whenever i make selections in Listboxes, without which all charts should be showing zero value.

Did you get my exact problem.

Regards

Default value as null when there is no selections made.

Thu, 22 Mar 2012 06:59:54 GMT

which fileds are u having in Multibox and Listboxes.

Instead of Getcurrentselection....u can use getfieldselection..in which u can give the name of the field for which u want to show data. Also bypass the filednames of Multiboxes by using set analysis.

If possible can u gve some dummy data.

Re: Default value as null when there is no selections made.

Thu, 22 Mar 2012 07:13:37 GMT

See the attached App.

In this when u select values in Listboxes then only Testubes gets filled up .

If we make any selections on multiboxes then data is not affected in testubes.

Re: Default value as null when there is no selections made.

SunilChauhan — Thu, 22 Mar 2012 07:20:41 GMT

see the attached file

you are excluding the selection of field in multibox in expression

CustNo=,Customer=

thats why its not reflecting

if you to reflect on multibox selection then

write

sum(if(vtest=0,0 ,Sales)) in expression

and in variable

count(GetFieldSelections(SO,',' )) + count(GetFieldSelections(Region,',' )) + count(GetFieldSelections(CustNo,',' )) + count(GetFieldSelections(Customer,',' ))

hope this helps

Default value as null when there is no selections made.

Thu, 22 Mar 2012 07:25:58 GMT

Hi Sunil,

I think that it is the rquirement of srmsagargupta that the data in testube should not reflect when values of mutibox fields are selected.

That is why i have bypassed those values.

That is why i have provided him the above solution.

Default value as null when there is no selections made.

Thu, 22 Mar 2012 07:27:46 GMT

Hey Erika i saw that QV files and its working well, i tried the same with mine but it failed. i am sorry for dummy data. Is it possible to discuss on Skype if you won't mind.

Regards

Sagar Gupta

Default value as null when there is no selections made.

Thu, 22 Mar 2012 07:33:52 GMT

Can I take ur remote through team viewer. or u can just scramble ur data and debug it on few lines and send me the application.

go to Document properties and choose scrambling tab.

In this u can select the fields to scramble which u don't want to disclose . Do this process in a Copy of ur application.

I don't have my lappy so can chat on skype.

Default value as null when there is no selections made.

Thu, 22 Mar 2012 07:39:27 GMT

Hi Erika,

I will try to give a mock data to you. Plzz give me some time.

Regards

Sagar Gupta