expression ignore filter

[JoseGarcia]

Hi there, 

I have a series of KPIs where two filters are applied: EightD.Solving_Cluster & EightD.Project_Cluster 

I'd like the expression below to ignore EightD.Project_Cluster filter selection.

=Count({<[EightD.Flag_D1mnthEQCutOfDate]={1},[EightD.Solving_Cluster], [EightD.Kx_Classification]={'K1S','K2'} >} distinct [%ID_8D])

Any ideas how to insert ignore EightD.Project_Cluster filter?

Thanks a million

[steeefan · Accepted solution]

This should do the trick:

=Count({<[EightD.Flag_D1mnthEQCutOfDate]={1},[EightD.Solving_Cluster], [EightD.Kx_Classification]={'K1S','K2'}, EightD.Project_Cluster= >} distinct [%ID_8D])

[qv_testing]

Try this..

=Count({<[EightD.Flag_D1mnthEQCutOfDate]={1},[EightD.Solving_Cluster], [EightD.Kx_Classification]={'K1S','K2'},  EightD.Project_Cluster= >} distinct [%ID_8D])

[anat · Accepted solution]

=Count({<[EightD.Flag_D1mnthEQCutOfDate]={1},[EightD.Solving_Cluster], [EightD.Kx_Classification]={'K1S','K2'}, [EightD.Project_Cluster]=>} distinct [%ID_8D])

[MarcoWedel]

hope this helps:

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se...