Enable Condition

[Frédéricdh]

Hello,

i try to show only a part of the data in my pivot table and that why I want to use "Enable Condtion" in the setting for selected Dimension.

My Dimension are Week name JW like 202301, 202302, 202303 and so on. And I try to filter with this:

= if (JW>= (Year(addmonths(Today(1),-1) ) *100 + Week(addmonths(Today(1),-1))) and JW <= (Year(addmonths(Today(1),1))*100 + Week(addmonths(Today(1),1))) , JW )

Why does it not work? Qlik show in the pivot table every thing? and how to convert 202302 in date or a date like 202302 in number?

Best Regards

Frédéric

[rubenmarin]

Hi, the 'Enable condition', is to enable or disable the full dimension, not the values of the dimension.

To filter dimension values you'll need a calculated dimension.

A calulated dimension is something that instead of just using the field, it uses an expression, so intead of use JW as dimension use:

= if (JW>= (Year(addmonths(Today(1),-1) ) *100 + Week(addmonths(Today(1),-1))) and JW <= (Year(addmonths(Today(1),1))*100 + Week(addmonths(Today(1),1))) , JW )