Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
soniasweety
Valued Contributor III

Only Null data

Hi all,

I have an issue with showing the null data .

My Requirment is:  I want to show the data where the completeddate is null/blank.

I have written this expression still its giving the wrong output can anyone suggest the correct expression?

=aggr(Only({$-<completiondate={"*"}>}numb),numb)

   

I have data like below   :

   

numbtypecompletedatevalues purchase
1A10-Jan-17100No
2X11-Jan-17101yes
3C12-Jan-17102No
4G13-Jan-17103yes
5B104yes
6J105yes
7ER106no
8GR17-Jan-17107no
9HET18-Jan-17108yes
Tags (3)
1 Solution

Accepted Solutions

Re: Only Null data

Then, My expression not working for you?

Only({<completedate = {"=Len(completedate)=0"}>}completedate)


Life is so rich, and we need to respect to the life !!!
24 Replies

Re: Only Null data

try like this

if(len(trim(completeddate))=0,completeddate)


then suppress null in the dimension option

MVP
MVP

Re: Only Null data

Where are you trying this expression? creating a list box? in chart dimension? ..

soniasweety
Valued Contributor III

Re: Only Null data

I want to list the numbers where the completedate is null.     I want to display in qliksense  table box.

Re: Only Null data

May be this? I assume tabular object not table box. Set analysis, Like below?

Only({<completedate = {"=Len(completedate)=0"}>}completedate)


OR


If it is in simple table box, May be this?

LOAD * Inline [

numb, type, completedate, values, purchase

1, A, 10-Jan-17, 100, No

2, X, 11-Jan-17, 101, yes

3, C, 12-Jan-17, 102, No

4, G, 13-Jan-17, 103, yes

5, B, , 104, yes,

6, J, , 105, yes,

7, ER, , 106, no,

8, GR, 17-Jan-17, 107, no

9, HET, 18-Jan-17, 108, yes

] Where Len(completedate) = 0;

Life is so rich, and we need to respect to the life !!!

Re: Only Null data

We don't have the option to add expression for table box ...are you working on the straight table/Pivot ? could share the sample app

soniasweety
Valued Contributor III

Re: Only Null data

Avi,

In qliksense table box is nothing but straight table,

I need output like below in straight table

because only 5,6  don't have the complete date

B104yes
6J105yes

Re: Only Null data

Why not 7?

Life is so rich, and we need to respect to the life !!!
soniasweety
Valued Contributor III

Re: Only Null data

sorry 7 also I missed it while copyingSmiley Sad

Re: Only Null data

Then, My expression not working for you?

Only({<completedate = {"=Len(completedate)=0"}>}completedate)


Life is so rich, and we need to respect to the life !!!
Community Browser