Dimension is a variable

[#1]

Hi Guys,

I have the date as a dimension for a bar chart. I want to use a slider as a variable tell the chart how many days to actually display. The practicality around this is not important, just would like to know how to add variables to a dimension like this.

Thanks all,

Byron

[#2]

Hi Byron,

You can filter the duration in the Dimension using if statement.

If (Date> from and Date<to, values)

if possible please upload sample QVW file with test data.

[erichshiino]

I agree with this approach.

An alternative would be to include a filter on all the expressions in the chart using Set-Analysis. The advantage would be the use of the same expressions in different object.

The expression would look like this:

sum({<DATE={'>$(date1)<=$(date2)'}> } VALUE)

Rgds,

Erich