Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can Qlikview do a table similar to this?
Name v // Day => | Monday | Tuesday | Wednesday | ... |
---|---|---|---|---|
Albert | sum(sales) | 123 | 456 | 789 |
Bryan | 234 | 567 | 890 | 10 |
Carl | 345 | 678 | 901 | 234 |
Thanks.
See attched, is this what you mean?
It is a QV pivot table with dimensions Name and Day (as columns), and expression sum(sales)
See attched, is this what you mean?
How do I set a dimension as a column? A pivot table will only let me Expand/Collapse groups...
You can click on a column header and pivot it to the top.
Perfect. Thank you!