topic Pivot grouping in QlikView

Pivot grouping

ramanannad — Thu, 02 Jun 2016 06:26:08 GMT

Dear Experts,

I have the simple file below loaded :

tmp:

LOAD

Group, --consists of group 1, group 2, group 3

Month, --consists of JAN, FEB, MAR

count(Customers)

FROM [lib://Data Source/somefile.csv]

(txt, utf8, embedded labels, delimiter is ',', msq) ;

My expected output is as such in a pivot table :

It shows the count of customers that changes group over the months, been trying for days to achieve this. No luck yet

Please help 🙂

Thanks

Ram

Malaysia

Re: Pivot grouping

qlikview979 — Thu, 02 Jun 2016 09:53:43 GMT

Hi Ramanan,

Please attached your source file.

Regards,

Mahesh.

Re: Pivot grouping

Anonymous — Thu, 02 Jun 2016 13:17:58 GMT

Hi Ramanan:

Use this expression.

=MaxString(Aggr(Only(Group),CountCust,Month))

Re: Pivot grouping

Anil_Babu_Samineni — Thu, 02 Jun 2016 13:42:31 GMT

Manuel,

Is there any chance to share that qvw for reference

Re: Pivot grouping

Anonymous — Thu, 02 Jun 2016 13:56:26 GMT

Yes, there you have.

Thanks!!

Re: Pivot grouping

ramanannad — Sun, 05 Jun 2016 15:28:59 GMT

Great share Manuel, Thanks

But am afraid that I missed out an important detail in my previous explanations, the data is actually granular down to the individual customerID rather than a count of customers, with this granular level table, how do we achieve the mentioned pivot table? Kindly help

tmp:

LOAD

Group, --consists of group 1, group 2, group 3

Month, --consists of JAN, FEB, MAR

count(CustomerID)

FROM [lib://Data Source/somefile.csv]

(txt, utf8, embedded labels, delimiter is ',', msq) ;