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
devarasu07
Honored Contributor II

Re: Only Null data

Hi,

Try this,

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

Capture.JPG

d_prashanthredd
Contributor III

Re: Only Null data

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
Valued Contributor III

Re: Only Null data

thanks but I need to do in qliksense

soniasweety
Valued Contributor III

Re: Only Null data

no not working

Re: Only Null data

Why? Show me the image?

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

Re: Only Null data

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
Honored Contributor III

Re: Only Null data

Dimension :numb    // and others

Expression

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

Regards,

Antonio

soniasweety
Valued Contributor III

Re: Only Null data

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

d_prashanthredd
Contributor III

Re: Only Null data

PFA..

Re: Only Null data

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;

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)