Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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