Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
MVP
MVP

Re: Only Null data

May be try putting aggr() around like:

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

soniasweety
Valued Contributor III

Re: Only Null data

thanks anil

but I want it to be done in front end only not in script.

antoniotiman
Honored Contributor III

Re: Only Null data

Then

Calculated Dimension

=Aggr(If(Len(Trim(completedate))=0,numb),numb)

Check 'Suppress value when null' and uncheck Suppress 0 values

Re: Only Null data

I think you miss understand the Qliksense? May be you are new to QS. Read the article how we can create measure / dimension in QS from community

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

Re: Only Null data

thanks all I will check with original data and confirm you .