topic Re: IF expression for dynamic dimension in QlikView

IF expression for dynamic dimension

Tue, 18 Nov 2014 11:14:49 GMT

Hi,

im trying to show less uninmportant data with a dynamic dimension.

the table should show item categories, but only those which content has changed.

so if a category has not changed, it should not show up in the table - but the category ID is still there.

the goal is to only show items in a dimension which meet conditions of an IF expression.

IF(

sum({<[month]={'$(mon_A)''}>}distinct data_cat)<>

sum({<[month]={'$(mon_B)'}>}distinct data_cat),

sum(distinct ID_cat)

)

The Editor shows "Expression OK" but the Table shows an error in the dynamic expression

Re: IF expression for dynamic dimension

Gysbert_Wassenaar — Tue, 18 Nov 2014 11:25:47 GMT

If you're using that expression as a calculated dimension then you'll have to specify over which dimensions it should be aggregated. Something like =aggr( if(......) , DimA, DimB,...., DimX)

Re: IF expression for dynamic dimension

miikkaqlick — Tue, 18 Nov 2014 11:35:53 GMT

Hi!

You have extra ' -sign in first set statement.

You could also try instead of $(mon_A) try $(=mon_A)

Br,

Miikka

Climber