Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

suppress dimension when expression is null

Hi!

I've got a table with "StartTime" as dimension and "if(below(startTime)>$(Time),SignalDescription,null()) as expression.

the outout is like:

02/12/2011 15:31:13   

02/12/2011 15:32:02   

02/12/2011 15:32:34   

02/12/2011 15:33:00   

02/12/2011 15:33:07   

02/12/2011 15:33:47    SignalDescr1

02/12/2011 15:34:01    SignalDescr2

02/12/2011 15:34:24   

02/12/2011 15:35:16   

02/12/2011 15:36:10   

02/12/2011 15:36:33   

02/12/2011 15:39:02   

02/12/2011 15:39:55   

02/12/2011 15:40:08    SignalDescr3

02/12/2011 15:40:16    SignalDescr4

but i want:

02/12/2011 15:33:47    SignalDescr1

02/12/2011 15:34:01    SignalDescr2

02/12/2011 15:40:08    SignalDescr3

02/12/2011 15:40:16    SignalDescr4

Have you got any suggestions?

Regards

-Davide

11 Replies
Not applicable
Author

Simply do what you have written in your heading:
DIM1: Date
DIM2: =if(len(trim(Value))>0, Time)
EXP1: Value
plus:
Suppress when  value is null: on

Message was edited by: maha1985

Not applicable
Author

with above o below function i must use only 1 dimension