Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Pivot table a few questions

Hi guys

Pivot Tables have never been my friend, I hope someone can help me out.

I have a QV load coming from excel, where I have a list of activities, then sub categories,the volume of Sub categories, and the time it takes to complete each of these sub categories.

I wish to create a Pivot table

That shows All the Activities, but the top 5 Sub categories, Based on time to complete, then the rating of where this activity is based on Volume.

Please see example this is the source data

ActivitySub categoryNumberTime to complete
ShoppingGrocery1052
ShoppingFish100155
ShoppingVeg1527
ShoppingMeat2233
ShoppingChicken7277
ShoppingHousewares1885
GardeningWatering155
GardeningPlanting8510
GardeningPruning5515
GardeningTriming10020
GardeningHoeing7225
GardeningDigging10030

I would wish it pivot to look like the following data;

ActivitySub categoryNumberTime to complete
ShoppingFish1155
ShoppingHousewares485
ShoppingChicken277
ShoppingGrocery552
ShoppingMeat333
GardeningDigging130
GardeningHoeing325
GardeningTriming120
GardeningPruning415
GardeningPlanting210

So,

The number is now the position it held in the overall run of things

And only the highest 5 time to completes per category is displayed,

Is this possible, any help or direction would be greatly appreciated

Thanks

A

1 Solution

Accepted Solutions
chauhans85
Esteemed Contributor

Re: Pivot table a few questions

see the attached for accurate result

8 Replies
chauhans85
Esteemed Contributor

Re: Pivot table a few questions

hope the attached file help u

Re: Pivot table a few questions

Hi,

See the attached sample might it will helps to create a pivot table.

Regards

Anand

Not applicable

Pivot table a few questions

Thanks Sunil,

Im sorry I had simplified my sample data, the number is actually an Expression , I tried to follow your sample and put it in as a calculated demension, but I get error in calc, is it possible to do the same as your sample, while having the volume as an expression ?

Thanks

A

Not applicable

Pivot table a few questions

Sorry Volume and Time to complete as an Expression as they are BOTH calculated

Thanks

chauhans85
Esteemed Contributor

Re: Pivot table a few questions

did u want like this

see attached

thanks

Sunil

Re: Pivot table a few questions

Hi,

Please check the sample i think it will helps you.

Regards,

Anand

chauhans85
Esteemed Contributor

Re: Pivot table a few questions

see the attached for accurate result

Not applicable

Re: Pivot table a few questions

Thanks a million guys

All samples are very helpful, I am going to work through these today and Ill post back any further queries,

Thanks again ,

A

Community Browser