Discussion board where members can get started with QlikView.
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:
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:
Can anyone offer any advise with this? Thanks
You can use a Pivot table to do what you are trying to do.
See the attached qvw file for reference.
Absolutely fantastic, works perfectly. Thank you so much
No problem Matt
Glad I was able to help.