Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
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
Highlighted

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
Highlighted

Re: Only Null data

try like this

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


then suppress null in the dimension option

Highlighted
MVP
MVP

Re: Only Null data

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

Highlighted
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.

Highlighted

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)
Highlighted

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

Highlighted
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
Highlighted

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:(

Highlighted

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