suppress dimension when expression is null

[#1]

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

[jjfabian]

In your chart, go to the dimension tab an select the option "Suppress when value is null" for your dimension.

[#3]

there is already the check on "Suppress when value is null"!

[#4]

Hi,

Try to- if(below(startTime)>$(Time),SignalDescription,0) and theb 'Suppres Zero-Values'  at the presentation tab

[#5]

No, it doesn't work.... (there is also suppres null-values)

[#6]

I know, but it didn't work for you,

are you sure that your expression is getting the result you want?

if you'll attach an example it be more clearly.

[ekech_infomotio]

... your  dimension is named "StartTime"? And you have "startTime" in your expression? QV is mostly case-sensitive - perhaps is this the reason why you don't get NULL-values.

regards,

Edgar

[#8]

sorry my fault, it is always "Start Time" but in QV i wrote it right

[ekech_infomotio]

OK, then you should make sure that QV can compare your timestamps - is your variable $(Time) interpreted as date? is your StartTime correctly interpreted, so QV can compare StartTime with $(Time) ? If in doubt, try comparing real numeric "if(num(below(StartTime))>num($(Time)),SignalDescription,null())".

regards,

Edgar

[#10]

the comparsion is ok, indeed it works