Only Null data

[soniasweety]

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   :

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

[tresB]

May be try putting aggr() around like:

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

[soniasweety]

thanks anil

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

[antoniotiman]

Then

Calculated Dimension

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

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

[Anil_Babu_Samineni]

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

[soniasweety]

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