topic Dimension is a variable in QlikView

Dimension is a variable

Thu, 14 Apr 2011 13:30:01 GMT

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

Dimension is a variable

Thu, 14 Apr 2011 14:03:15 GMT

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.

Dimension is a variable

erichshiino — Thu, 14 Apr 2011 14:48:23 GMT

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