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