Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

CrossTab Style Chart

Hi everyone

Would really appreciate help with this if possible.

Have a QVD file that contains all stock codes, day of week total (every Monday shown), and quantity sold.

The QVD looks something like this:

   

StockCodeWeekCreatedQty Sold
Code118/05/20151
Code111/05/20152
Code104/05/20153
Code127/04/20154
Code218/05/201510
Code211/05/201511
Code204/05/201512
Code227/04/201513
Code318/05/201520
Code311/05/201521
Code304/05/201522
Code327/04/201523
Code418/05/201530
Code411/05/201531
Code404/05/201532
Code427/04/201533

I am trying to turn this into a horizontal straight table, that will look like this.

The stock code (Code1, Code2 etc) will be listed in the first column, the week created will be in the column header, with the QtySold then in the individual cells:

  

                Qty Sold Chart
    18/05/201511/05/201504/05/201527/04/2015
Code11102030
Code22112131
Code33122232
Code44132333

Can anyone offer any advise with this? Thanks

4 Replies

Re: CrossTab Style Chart

You can use a Pivot table to do what you are trying to do.

Re: CrossTab Style Chart

This?

Capture.PNG

See the attached qvw file for reference.

Best,

Sunny

mattbrain
New Contributor

Re: CrossTab Style Chart

Hi Sunny

Absolutely fantastic, works perfectly. Thank you so much

Re: CrossTab Style Chart

No problem Matt

Glad I was able to help.

Best,

Sunny