logic

[panipat1990]

Hi Team,

I have a table and there is null Value..I want to remove those null value Without using option suppress null value..Here  i am attaching table.please help me.

[sunny_talwar]

May be use this in your set analysis:

Sum({<Code = {'*'}>}Amount)

[#3]

hi

you can simply load table with where condition.

like

load * from table

where Code<>null();

----------------------------------------

or

load * from table

where Code>=0;

[panipat1990]

Hi sunny,

I want to make two  button ..when i click on first button then it show with null value..and when i click another button then it show without null value..

[sunny_talwar]

May be something like this:

If(vVar = 1, Sum(Amount), Sum({<Code = {'*'}>} Amount))

Here you will set the vVar using a button action

[trdandamudi]

One more is:

If(vNullNotNull = 1, Sum(Amount), Sum({<Code = {"=Len(Code)>0"}>} Amount))

Note: Set vNullNotNull variable using button action.

[panipat1990]

Hi sir,

Please share me qvw file

[trdandamudi]

Sunny,

When I use the below two expressions I am getting the same result as 15,900:

=Sum({<Code = {'*'}>} Amount)        <-------This should give 10,600

=Sum(Amount)                               <-------This should give 15,900

I am using version 11.20. Do you think it has to do something with the version ?

[sunny_talwar · Accepted solution]

Here you go

.

[trdandamudi]

Sunny,

Just want to share this with you..

When I open your dashboard and used this expression =Sum({<Code = {'*'}>} Amount) I am getting 10,600. If I use the same expression in my qlikview dashboard I am getting 15,900.

I am using version 11.20 and might be there is a bug.