Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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
24 Replies
devarasu07
Master II
Master II

Hi,

Try this,

=if(len(completedate)=0,completedate)

Capture.JPG

d_prashanthredd
Creator III
Creator III

You are looking for this..

or you want to display complete data and a status flag for blank dates?

Expression:

if(completedate='' or completedate= Null() or completedate='-', completedate)

soniasweety
Master
Master
Author

thanks but I need to do in qliksense

soniasweety
Master
Master
Author

no not working

Anil_Babu_Samineni

Why? Show me the image?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Sony,

Please find the attachment.

In that In deimesion i Calculate dimension.

=if(len(trim(completedate))<=0, completedate)

And enable Suppress When value is null checkbox

Exp is Simple Sum(values)

Thanks,

Arvind patil

antoniotiman
Master III
Master III

Dimension :numb    // and others

Expression

Sum({<numb={'=Len(Trim(completedate))=0'}>} values)

Regards,

Antonio

soniasweety
Master
Master
Author

I don't have any measures just want to show the all details  where the date value is null.

d_prashanthredd
Creator III
Creator III

PFA..

Anil_Babu_Samineni

Again, please have a look all possible response

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;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)