Where clause in a dimension in Multi box

[punitpopli]

Hi ,

I want to use the date field (DATA_MTH_GRP_YYYYMM_NBR) in the multi box from dimension table and I don't want the multi box values to be filtered from one of the date column (DATA_MTH_YYYYMM_NBR) in Fact table

Have already tried Maxstring() but this is not working, attached is the QVW for reference

Does anyone have faced the same issue in the past?

Thanks

Punit

[Gysbert_Wassenaar]

I want to use the date field (DATA_MTH_GRP_YYYYMM_NBR) in the multi box from dimension table and I don't want the multi box values to be filtered from one of the date column (DATA_MTH_YYYYMM_NBR) in Fact table

As far as Qlikview is concerned there is only one field with the name DATA_MTH_GRP_YYYYMM_NBR. So what you want is not possible.