topic Re: ignore dimension in expression in QlikView

ignore dimension in expression

Sun, 07 Jul 2013 13:24:54 GMT

Hi,

I have the following test expression to ignore dimension in sum. However, the ignore dimension is not working

count({$<CaYear=>}IncidentID)

While CaYear is also selected in dimension fields

Can someone please tell me whats wrong with this expression

Arif

luciancotea — Sun, 07 Jul 2013 13:35:39 GMT

Ignore selection in Dimension: count({$<CaYear=>}IncidentID)

Ignore All Dimensions in chart: count(TOTAL IncidentID)

Ignore Specific Dimension (eg: Dim3) in chart: count(TOTAL <Dim1, Dim2, Dim4> IncidentID)

Sun, 07 Jul 2013 13:47:56 GMT

count({$<CadYear=>}IncidentID) is not ignoring Cad Year Dimension. Please see attached image

Arif

luciancotea — Sun, 07 Jul 2013 14:46:53 GMT

Read again what I said. I think you want option 2.

Sokkorn — Mon, 08 Jul 2013 01:21:48 GMT

Hi Arif,

You can try =Count({1} IncidentID) and see the result.

Regards,

Sokkorn