Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
MVP
MVP

Re: Only Null data

May be try putting aggr() around like:

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

Highlighted
soniasweety
Valued Contributor III

Re: Only Null data

thanks anil

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

Highlighted
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

Highlighted

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

Re: Only Null data

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