Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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)


Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

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;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
soniasweety
Valued Contributor III

Re: Only Null data

sorry 7 also I missed it while copying:(

Re: Only Null data

Then, My expression not working for you?

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


Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post