Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
ehasnawi98
New Contributor II

Why the data with null value still appear in my result

so i have a data , lets say

Project             Sprint

A                         Sprint 1 , Sprint 2 , Sprint 3

B                           

C                        Sprint 1 , Sprint 2

D                        Sprint 1 , Sprint 2, Sprint 3 , Sprint 4

 

so i try to load

Subfield("Sprint",",",1) as first start sprint

Subfield("Sprint",",",-1) as end sprint time

it appear perfectly , but the data with null sprint value will appear as " - " both in first and end sprint..

 

Result (not what i want)

Proj            first sprint            end sprint

A                  sprint 1                  sprint 3

B                   -                                 -                     (this should be not appear)

C                 sprint 1                     sprint 2

D                 sprint 1                    sprint 3

 

i already try with wildmatch("Sprint", '-')=0 ,  not wild match("Sprint",'-') , i count the len("Sprint")>1 , and it still appear the project with anonymous first and end sprint known as '-',  is there anything wrong ?

Labels (4)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Why the data with null value still appear in my result

Put condition

where(len(trim(Sprint))>0

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: Why the data with null value still appear in my result

Put condition

where(len(trim(Sprint))>0

View solution in original post