topic Re: logic in QlikView

logic

panipat1990 — Mon, 26 Jan 2026 18:19:17 GMT

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.

Re: logic

sunny_talwar — Tue, 10 May 2016 19:03:00 GMT

May be use this in your set analysis:

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

Re: logic

Tue, 10 May 2016 19:09:26 GMT

you can simply load table with where condition.

load * from table

where Code<>null();

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

load * from table

where Code>=0;

Re: logic

panipat1990 — Tue, 10 May 2016 19:11:28 GMT

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

sunny_talwar — Tue, 10 May 2016 19:14:59 GMT

May be something like this:

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

Here you will set the vVar using a button action

Re: logic

trdandamudi — Tue, 10 May 2016 19:18:44 GMT

One more is:

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

Note: Set vNullNotNull variable using button action.

Re: logic

panipat1990 — Tue, 10 May 2016 19:24:35 GMT

Hi sir,

Please share me qvw file

Re: logic

trdandamudi — Tue, 10 May 2016 19:24:39 GMT

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

sunny_talwar — Tue, 10 May 2016 19:31:13 GMT

Here you go

Re: logic

trdandamudi — Tue, 10 May 2016 19:38:58 GMT

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.

Re: logic

sunny_talwar — Tue, 10 May 2016 19:44:55 GMT

When you use my qvw you are getting 10,600 and when you use your qvw you are getting 15,900 with my proposed expression? Are you doing an inline load? In other words, do you have Code truly null? Can you share your qvw?

Re: logic

panipat1990 — Tue, 10 May 2016 19:50:16 GMT

Hi sunny,

This is helpful for me.But i asked one requirement load multiple csv file in qlikview...

I do have 40 to 50 csv file and i want to load multiple csv file in qv.i already shared 5 csv file you..how is it possible..sir please help me

Re: logic

trdandamudi — Tue, 10 May 2016 19:51:40 GMT

Here is the file... Yes, I am using Inline load. Am I doing something wrong here !

Re: logic

sunny_talwar — Tue, 10 May 2016 19:51:48 GMT

I can look at it later today. Won't be able to create a sample while at work as it takes long time to create and check. Sorry about that

Re: logic

sunny_talwar — Tue, 10 May 2016 19:55:48 GMT

When you create fields through Inline, they look to be null but they are not. I forced them to be null:

Table:

LOAD If(Len(Trim(Code)) > 0, Code) as Code,

Amount;

LOAD * Inline [

Code, Amount

500, 1200

610, 1300

610111010, 100

5001, 1400

610111011, 1500

6101, 1600

500101013, 1700

610, 1800

,1900

,3400

];

This brings an interesting point. My solution will only work if the code is truly null, where as your will work in all scenarios. I usually like using Len(Trim()) over IsNull(), but I guess in this scenario I was using set analysis and that is why I stayed by {'*'} syntax assuming that the value is truly null. If it is not truly null, I would suggest Gourav to use your solution

Re: logic

trdandamudi — Tue, 10 May 2016 20:07:25 GMT

Interesting..... Thank you...