topic expression not filtering view in QlikView

expression not filtering view

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a very basic Chart. I want to list all accounts where the flag on the account = 'Yes'. The two Expressions are:-

1. count(distinct AccountNo)

2. IsLocalBankFlag='Yes'

the second expression should filter out accounts but does nothing. The two fields are in the same table. Can I not do this?

Any help appreciated.

Cheers

MK_QSL — Thu, 03 Mar 2016 09:02:54 GMT

count({<IsLocalBankFlag = {'Yes'}>}distinct AccountNo)

Anonymous — Thu, 03 Mar 2016 09:08:38 GMT

thanks Manish