topic Index for alpha and exclude alpha from count in QlikView

Index for alpha and exclude alpha from count

Thu, 18 Aug 2011 21:22:25 GMT

How do I index for alpha letters and filter them from my count?

Tag#
520657A
520657B
230626
252067A
520657
252067
252376

Index for alpha and exclude alpha from count

swuehl — Thu, 18 Aug 2011 21:57:55 GMT

If you just need a count, you may use

=NumericCount([Tag#])

(or the complement: TextCount([Tag#]) )

Regards,

Stefan

Index for alpha and exclude alpha from count

swuehl — Thu, 18 Aug 2011 22:11:47 GMT

And if you need to do something else, you could use the boolean functions

isNum([Tag#]) resp. isText([Tag#]) to distinguish the Tags with the alphanumeric suffix from the pure numerical ones.

Hope this helps

Index for alpha and exclude alpha from count

its_anandrjs — Fri, 19 Aug 2011 18:26:36 GMT

Hi,

It is your column or the count, if it is a column so you need to put a code like =keepchar(Tag#,0123456789) to remove alpha by this you able to remove alpha from column if it is so.

Hope this helps you

Regards,

Anand