Formula

[JoseGarcia]

Hi, 

could anyone assist with this formula? 
It is giving me error.

=if({<[EightD.D8 - Closed On Frmted]={'31/12/9999'}>} Count({<[EightD.Kx_Classification]={'K1S'}>}[EightD.Kx_Classification])

Thanks

[vinieme12 · Accepted solution]

as below

= Count({<[EightD.Kx_Classification]={'K1S'},[EightD.D8 - Closed On Frmted]={'31/12/9999'}>}[EightD.Kx_Classification])

Refer this article on set analysis

https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/