Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ignore dimension in expression

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

4 Replies
luciancotea
Specialist
Specialist

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)




Not applicable
Author

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

Capture1.PNG

Arif

luciancotea
Specialist
Specialist

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

Sokkorn
Master
Master

Hi Arif,

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

Regards,

Sokkorn