Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

panipat1990
Contributor II

logic

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.

1 Solution

Accepted Solutions

Re: logic

Here you go

Capture.PNG.

Capture.PNG

15 Replies

Re: logic

May be use this in your set analysis:

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

Not applicable

Re: logic

hi

you can simply load table with where condition.

like

load * from table

where Code<>null();

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

or

load * from table

where Code>=0;

panipat1990
Contributor II

Re: logic

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..

Re: logic

May be something like this:


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


Here you will set the vVar using a button action

trdandamudi
Honored Contributor

Re: logic

One more is:

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



Note: Set vNullNotNull variable using button action.

panipat1990
Contributor II

Re: logic

Hi sir,

Please share me qvw file

trdandamudi
Honored Contributor

Re: logic

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 ?

Re: logic

Here you go

Capture.PNG.

Capture.PNG

trdandamudi
Honored Contributor

Re: logic

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.