Set Analysis (count expression function)

[#1]

The following function not working any one help on this.

I am tring to get count where account sub string = 0000 then those records should be count.

=count({$<mid(ACCOUNT_NO,26,4) = {'0000'}>} distinct ACCOUNT_NO)

[stephencredmond]

Hi,

Remember that the Set Analysis search condition is anything that you could type into a List Box search.  Then the answer is:

=count({$<ACCOUNT_NO = {'*0000*'}>} distinct ACCOUNT_NO)

Regards,

Stephen

Stephen Redmond is author of QlikView for Developer's Cookbook
He is CTO of CapricornVentis a QlikView Elite Partner. We are always looking for the right people to join our team.
Follow me on Twitter: @stephencredmond

[#3]

Thanks it helps lot for me.

On Thu, Jun 27, 2013 at 5:17 PM, Stephen Redmond