1 Reply Latest reply: Mar 24, 2016 12:50 PM by Gysbert Wassenaar RSS

    unable to exclude null in date field

      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..