topic suppress dimension when expression is null in QlikView

suppress dimension when expression is null

Fri, 03 Feb 2012 09:17:57 GMT

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

suppress dimension when expression is null

jjfabian — Fri, 03 Feb 2012 09:28:52 GMT

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

suppress dimension when expression is null

Fri, 03 Feb 2012 09:46:51 GMT

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

suppress dimension when expression is null

Fri, 03 Feb 2012 10:01:10 GMT

Hi,

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

suppress dimension when expression is null

Fri, 03 Feb 2012 10:04:43 GMT

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

suppress dimension when expression is null

Fri, 03 Feb 2012 10:14:34 GMT

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.

suppress dimension when expression is null

ekech_infomotio — Fri, 03 Feb 2012 10:16:59 GMT

... 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

suppress dimension when expression is null

Fri, 03 Feb 2012 10:22:56 GMT

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

suppress dimension when expression is null

ekech_infomotio — Fri, 03 Feb 2012 10:31:24 GMT

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

suppress dimension when expression is null

Fri, 03 Feb 2012 10:40:00 GMT

the comparsion is ok, indeed it works

Re: suppress dimension when expression is null

Fri, 03 Feb 2012 10:51:49 GMT

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

suppress dimension when expression is null

Fri, 03 Feb 2012 13:28:21 GMT

with above o below function i must use only 1 dimension