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: 
n1ef5ng1
Creator
Creator

Restrict if there is value, urgent

Hi gurus,

I am currently doing a comparison between YEAR on YEAR change data. Bascially a Jan 2012 column is derived from the differences of Jan 2012 and Jan 2011. The data that I got is correct but however, it list out all the Dimension even though is blank.

untitled.bmp

Here is my code,

=if( Before( Sum (IF(Status <> 'LHP', TEU,0)) , 12)  = 0
  OR IsNull( Before( Sum (IF(Status <> 'LHP', TEU,0)) , 12)) = -1, null(),


if( MonthEnd ( MAX( Date ) ) <> var_EndDate AND MonthEnd( MAX ( Date ) )
= MonthEnd( var_EndDate ) ,
Sum({<
Class= {'Lade'}
,Status = {'TP'}
,Loading = {'ID*'}
>} TEU / Day( var_EndDate )) * Day(MonthEnd(MAX ( Date )))

,

(Sum({<
Class= {'Lade'}
,Status = {'TP'}
,Loading = {'ID*'}
>} TEU)

/
Before( Sum({<
Container_Class_Name = {'Laden'}
,Derived_Status = {'TSHIP'}
,Loading = {'ID*'}
>} TEU) , 12)

*100))-100)

//if Statement(MonthEnd) means the data will check which is the latest month and EXTRAPOLATED the value,

the first two statement of IF is to eliminate values from 2011 as there is no data from 2010 to substract on.

I have check suprress null values etc,

is something to do with the code that display everything.

Any gurus can help for this?

0 Replies