topic Re: unable to exclude null in date field in QlikView

unable to exclude null in date field

Thu, 24 Mar 2016 16:46:32 GMT

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

Re: unable to exclude null in date field

Gysbert_Wassenaar — Thu, 24 Mar 2016 16:50:43 GMT

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

Re: unable to exclude null in date field

TheRoo — Fri, 02 Oct 2020 15:42:22 GMT

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’