Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be use this in your set analysis:
Sum({<Code = {'*'}>}Amount)
hi
you can simply load table with where condition.
like
load * from table
where Code<>null();
----------------------------------------
or
load * from table
where Code>=0;
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..
May be something like this:
If(vVar = 1, Sum(Amount), Sum({<Code = {'*'}>} Amount))
Here you will set the vVar using a button action
One more is:
If(vNullNotNull = 1, Sum(Amount), Sum({<Code = {"=Len(Code)>0"}>} Amount))
Note: Set vNullNotNull variable using button action.
Hi sir,
Please share me qvw file
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 ?
Here you go
.
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.