topic Re: Expression returns NULL value in QlikView

Expression returns NULL value

alwinsch — Fri, 12 Feb 2016 11:37:45 GMT

Hi all,

I have 2 tables:

Projects: ID, project_name, profitA, profit,Chance_on_succes, leader
Teamleader: leader, Leader_name

Now i want a table with dimension Teamleader
and as expression sum(profitA + profitB)/chance_on_succes

The problem is if my teamleader has for every project the same chance_on_succes this works fine, but if he has multiple different chances, then we get no value returned.
how can we avoid this?

Kind Regards,

Alwin

Re: Expression returns NULL value

alwinsch — Fri, 12 Feb 2016 14:15:03 GMT

Hi all,

I solved it myself.

Created extra columns in the projects table Chance_profitA, chance_profitB

Which is calculated from ProfitA and chance_on_succes.

This way it works fine for me.

kind regards,

Alwin

Re: Expression returns NULL value

Chanty4u — Mon, 15 Feb 2016 04:52:13 GMT

please close this thread as correct.

Thanks

Suresh