topic Re: Need Help in QlikView

Need Help

paulwalker — Wed, 18 Nov 2015 08:45:37 GMT

Hi Community,

I have one issue on Null values, i have to show null records in my Chart....

I am using Gantt chart..

My requirement is if EndDate=StartDate=Null then i want show symbol in Chart...

By default it showing Null values, if i am using this condition

Year([Site StartDate]) <=2018 its excluding Null values..

anything wrong here???

See this one particular case AO1EIK

Thanks in Advance

Re: Need Help

Mark_Little — Wed, 18 Nov 2015 08:57:39 GMT

Hi,

I am not a hundred percent sure what you are trying achive, But the condition would cause them to disappear and the fail it. Year([Site StartDate]) <=2018 .

Not always the best approach, but could you do something like

If(ISNULL(Field),'Value',

IF(Year([Site StartDate]) <=2018,'Your Expression' )

)

Mark

Re: Need Help

paulwalker — Wed, 18 Nov 2015 09:03:08 GMT

I need data only up to 2018 years records only...

if i have any null values i want to show symbol in my chart

Re: Need Help

sunny_talwar — Wed, 18 Nov 2015 09:45:41 GMT

See this one particular case AO1EIK

I don't see anything attach, did you mean to attach something with the post?

Year([Site StartDate]) <=2018 its excluding Null values..

Try this may:

Where Year([Site StartDate]) <= 2018 or Len(Trim([Site StartDate])) = 0;

Re: Need Help

paulwalker — Wed, 18 Nov 2015 10:15:58 GMT

Thanks Sunny ..!!!!

I got it .....