Filtering the Chart on the basis of selected Year text box

[Anonymous]

Hi ,

         I am trying to do below mentioned functionality using QlikView:

          1. Text Box 1 (1YR)

          2. TextBox 2(3 YR)

          3. BarChart (Dimension :Calendar, Expression on sales columns(SUM(Sales)

        When some one clicks on 1YR, it should filter the chart to display only 1 YR dates and sales. similiarly for 3 YR button also.. Attached the QVW file.

Thanks

Dasu.G

[#2 · Accepted solution]

Change your Dimension to:

=if([DATE(calendar_date)]>=vStartDate and [DATE(calendar_date)]<=vEndDate,[DATE(calendar_date)])

I used your field names, but I would recommend changing your DATE(calendar_date) to another name using 'As DateFieldName'. Hope that helps.

[#3]

Also, you will need to click 'Suppress when value is null' on the dimension. Forgot to mention that.