unable to exclude null in date field

[#1]

Hi Folks,

I am facing issue with a QlikSense task,

I attached the sample data and required output.

when i load the excel sheet data i got the null values..How to exclude the null values..?

In x-axis i want to show only latest 12 weeks data that should be like ww1,ww2,ww3,.....ww12. How to take it in week format as given..

Open & Close - Excluding Null Values

How to show "Open" Values in Left and "Close" Values in Right..

Thanks in advance..

Regards,

Venal

[Gysbert_Wassenaar]

Please don't clutter this site with duplicate discussions: unable to exclude null in date field

[TheRoo]

I’m trying to exclude (NotNull) from a Date field, although I can do it by:

= If (isnull(YourExpression),0,YourExpression), unfortunately it is converting all the other dates into just numbers, so in a nutshell how do a write the script to covert the number into ‘DD-MM-YY’