How to display Weekly data when selecting MonthYear in qlikview
I am facing a issue to display WeekEnd data when selecting MonthYear. When i am using hard coding at data base i am getting correct values. Same thing i am trying to using at expression. I am not getting right value.
Here WEEKEND is Saturday.
I have created a condition in Database like this.
and ((End_Date is Null and Start_Date <= '2018-10-20') or (End_Date > '2018-10-20' and Start_Date <='2018-10-20'))
the above condition is showing the data for third week end Saturday for 2018-10, i am getting total value is 228 for above condition. When i am taking hard-coding for each week values are coming fine. Same thing i need to take instead of hard-coding. When i am taking instead of hard-coding i am getting values for entire month i.e 188, but specific weekend the values are not correct. Can any one help me on this. Thanks in Advance