topic Re: Set Analysis (count expression function) in QlikView

Set Analysis (count expression function)

Thu, 27 Jun 2013 22:05:08 GMT

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 — Thu, 27 Jun 2013 22:17:46 GMT

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

Thu, 27 Jun 2013 22:29:25 GMT

Thanks it helps lot for me.

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