topic Subset of values in Chart Dimensions (Filter Chart dimensions) in QlikView

Subset of values in Chart Dimensions (Filter Chart dimensions)

Thu, 13 Aug 2009 18:05:18 GMT

Hi,

I have a chart that has 3 dimensions. One dimension has to dynamically display values for the next 21 days based on today's date. Today's date is stored in a variable.

Can someone guide me as to how to filter the Time field values (displayed as dimension in charts) based on a variable value?

Sai

Subset of values in Chart Dimensions (Filter Chart dimensions)

Oleg_Troyansky — Thu, 13 Aug 2009 19:59:04 GMT

You can replace your Dimension with the calculated Dimension and use IF condition to limit your dates:


if( date <= $(vToday) + 21 and date >= $(vToday), MyDimension, null())

notice that vToday is the variable. You also need to check "Suppress when null" checkbox.

good luck,

Oleg