Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please don't clutter this site with duplicate discussions: unable to exclude null in date field
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’