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.
rubyotero
New Contributor III

need help in crosstab pivot

hi im new in QV and i need your help

i have this flat tables

Customer
Month
Amt
DaveJan1,000
Dave
Feb500
DaveMay600
DaveDec

7000

JohnFeb5600
JohnMar

400

Into this kind of format

CustomerJanFebMarAprMay
Jun

JulAug.....DecTotal
Dave










John






















Hope you could help me....

1 Solution

Accepted Solutions
rubyotero
New Contributor III

need help in crosstab pivot

pivot success.jpg

wow thank you .. i already solve my prob....

4 Replies
Not applicable

need help in crosstab pivot

HI

Please find the image for your query. You have to select pivot table in the object selection and frist dim as Customer

Second dim as month

and in expersion you to select sum(amt)

com back to to presentaion tab (find the screen shot for the same)

select Month Diminsion and check the show patila sums check box.

and on the GUI select the mon the drag upward the blue arrow show in vertical way and leave in

Hope you got your answer

Regards

Venkatesh Salla

Qlikview_Example_Pivot.bmp

rubyotero
New Contributor III

need help in crosstab pivot

im using Persnal Ed of QV.. and i try to do what u are trying to say.. i still dont have a tabular month column..... i saw the blue arrow but it doesnt take effect...

Not applicable

need help in crosstab pivot

HI

Once you see blue arrow facing upwards then drag towards the right side of the oject near close button so that it chages from horizontal arrow to vrtical arrow

then release the mouse hold

Regards

Venkatesh Salla

rubyotero
New Contributor III

need help in crosstab pivot

pivot success.jpg

wow thank you .. i already solve my prob....

Community Browser