topic Re: Not isnull in QlikView

Not isnull

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I am trying to acheve the count of ID's when two or one field is is not null or not empty for which i am using the below formula which is not giving me proper result .

Can someone please correct me on this.

if(not IsNull(DeptID) or not IsNull(CustomID),Count({<Region={'Newyor'},Priority={'High','Medium'}>}SalesID)).

Thanks

Re: Not isnull

Anil_Babu_Samineni — Thu, 15 Oct 2020 06:10:33 GMT

Perhaps this?

if(Len(DeptID&CustomID)>0 ,Count({<Region={'Newyor'},Priority={'High','Medium'}>}SalesID))

Set Analysis

Count({<Region={'Newyor'},Priority={'High','Medium'}, SalesID={"=Len(DeptID&CustomID)>0"}>}SalesID)

Re: Not isnull

smilingjohn — Thu, 15 Oct 2020 06:25:14 GMT

Thanks for the reply @Anil_Babu_Samineni

sorry to say that your expression above is not working .

I tried both the expression but i dont get the expected result

Re: Not isnull

Chanty4u — Thu, 15 Oct 2020 06:38:15 GMT

can you try this?

Count({<Region={'Newyor'},Priority={'High','Medium'}, SalesID={"=Len(trim(DeptID&CustomID))>0"}>}SalesID)

Re: Not isnull

Anil_Babu_Samineni — Tue, 20 Oct 2020 16:00:11 GMT

@smilingjohn If my expression not working, Why did you accepted my solution? If you have another work around, You can put that and mark that as answer ..

Re: Not isnull

smilingjohn — Wed, 21 Oct 2020 08:33:07 GMT

@Anil_Babu_Samineni Your second expression did work , and thats the reason i marked it as accept solution .

Thanks