15 Replies Latest reply: Apr 20, 2012 9:18 AM by Karthikeyan B RSS

    Set Analysis Expression for Date range - Not working

      I have created a date filter (2 calendar controls) and I wanted to filter out the data in Pivot based on the date ranges

       

      Value for vStartDate & vEndDate can be obtained from the 2 calendar controls (the values are shown as numbers instead of Date format).

       

      When I issue the following, nothing is being displayed

       

      Sum({$<DateCol ={">=$(=Date(vStartDate)) <=$(=Date(vEndDate))"}>} Sales_Amount)

       

      but if I issue the below code, then the data is populating properly.

       

      Sum(IF(DateCol >= Date(vStartDate) and DateCol <= Date(vEndDate), Sales_Amount)

       

      I am new to QlikView and Set Analysis. I tried putting single quotes and double quotes, but nothing is coming.

       

      Please anyone help. Is expression case sensitive? (Here the case is correct only though)