Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
May be try putting aggr() around like:
Aggr(Only({<completedate = {"=Len(completedate)=0"}>}numb),numb)
thanks anil
but I want it to be done in front end only not in script.
Then
Calculated Dimension
=Aggr(If(Len(Trim(completedate))=0,numb),numb)
Check 'Suppress value when null' and uncheck Suppress 0 values
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
thanks all I will check with original data and confirm you .