Qlikview Count({< not working

[#1]

Hi All,

Please can you assist.

I have a QlikView dashboard reading from an Access database (Table that contains both April and May's file).

I then applied the following formula to a pivot table "

Count({<

[Turnover Trade Status]={'Amended','New'},

[Turnover Custody/FoP/FX]={''},

[Turnover Trade Type]-={'Position Transfer'}>}[Turnover Company])

with Dimensions Date.

However the formula does not calculate properly, it only calculates properly for the first month April and not May..

Many thanks,

[#2]

Thanks

[#3]

Thanks

[#4]

How do I close this thread Sunindia?

Thanks,

[sunny_talwar]

Click on Correct Answer for whomsoever's answer worked the best for you

Thank you for being prompt for my request.

Best,

Sunny

[#6]

Thank you