Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Expressions equal to ''

Hello all, this is a random observation, but some of my metrics aren't running properly. Whenever I want to count something and am trying to see when a cell is equal to null, nothing returns. The data is there, but nothing shows up anymore ever since the new updates on Qlik Sense Cloud. Any other ideas to count when a column is equal to Null, followed is my expression.

(count({$<[Dest. Handling Unit put]= {''}, [Warehouse Process Cat. Desc. put] = {'Putaway'}>} [Confirmed by put]))

+

(count({$<[Dest. Handling Unit put]= {''}, [Warehouse Process Cat. Desc. put] = {'Internal Warehouse Movement'}>} [Confirmed by put])/2)

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

Hi Joshua

One of the things I have trouble with in Qlik world is identifying nulls. It will show a null but not allow you to select one. Part of the problem is if your looking for a null in an associated table it seems to be different. I have some measures where the set analysis doesn't seem to work and where doing counts of what's missing i do a count of all minus where the value is populated.

So something like

(count({$<[Warehouse Process Cat. Desc. put] = {'Putaway'}>} [Confirmed by put]))

-(count({$<[Dest. Handling Unit put]-={''}, [Warehouse Process Cat. Desc. put] = {'Putaway'}>} [Confirmed by put]))

where the -={''} in the set analysis gives you the records where you have a value.

Also you can achieve OR logic in set analysis to avoid counting records that might satisfy both criteria if you have a need.

Ron

View solution in original post

1 Reply
Highlighted
Creator
Creator

Hi Joshua

One of the things I have trouble with in Qlik world is identifying nulls. It will show a null but not allow you to select one. Part of the problem is if your looking for a null in an associated table it seems to be different. I have some measures where the set analysis doesn't seem to work and where doing counts of what's missing i do a count of all minus where the value is populated.

So something like

(count({$<[Warehouse Process Cat. Desc. put] = {'Putaway'}>} [Confirmed by put]))

-(count({$<[Dest. Handling Unit put]-={''}, [Warehouse Process Cat. Desc. put] = {'Putaway'}>} [Confirmed by put]))

where the -={''} in the set analysis gives you the records where you have a value.

Also you can achieve OR logic in set analysis to avoid counting records that might satisfy both criteria if you have a need.

Ron

View solution in original post