topic Re: counting word occurence in QlikView

counting word occurence

Fri, 08 Feb 2013 09:01:32 GMT

Hello,

I'm having trouble counting occurence of words in a colum.

This is what I have:

Also, the column PRODUCT is an expression colum (firstsortedvalue)

What i'm looking for is the number of times PRODUCT 1, PRODUCT 2, PRODUCT 3 are occuring.

So i would like somthing like that:

Thanks a lot

Fri, 08 Feb 2013 09:13:08 GMT

SEE ATTACHEMENT

TAKE PIVOTE TABLE

DIMENSION- PRODUCT

EXPRESSION - COUNT(PRODUCT)

then output like this

*********************************************************************************************

OR IF YOU WRITE AT SCRIPT LABEL---

LOAD CUSTOMER,

PRODUCT

FROM

C:\Users\vishwaranjan\Desktop\TEST8.xlsx

(ooxml, embedded labels, table is Sheet1);

load PRODUCT, count(PRODUCT) AS OCCURENCE

RESIDENT A Group BY PRODUCT;

THEN OUTPUT LIKE THIS--

Fri, 08 Feb 2013 09:16:22 GMT

sorry, but where is it?

er_mohit — Fri, 08 Feb 2013 11:19:59 GMT

hiiii

see the attached file