Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Also, you will need to click 'Suppress when value is null' on the dimension. Forgot to mention that.