Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
ramanannad
New Contributor III

Pivot grouping

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 :

sample pivot.png

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

5 Replies
qlikview979
Valued Contributor

Re: Pivot grouping

Hi Ramanan,

Please attached your source file.

Regards,

Mahesh.

manucamon
Valued Contributor III

Re: Pivot grouping

Hi Ramanan:

Use this expression.

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

Snap.PNG

Re: Pivot grouping

Manuel,

Is there any chance to share that qvw for reference

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
manucamon
Valued Contributor III

Re: Pivot grouping

Yes, there you have.

Thanks!!

ramanannad
New Contributor III

Re: Pivot grouping

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) ;

sample pivot.png