Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am new to QV and I am struggling with crosstabs when loading data into Qlikview. Experts please guide me on how to work effectively with these crosstabs.
For example this is how my data looks like
Oct-14 | Nov-14 | Dec-14 | Jan-15 | Feb-15 | Mar-15 | Apr-15 | ||||||||||
products | Product Desc | Sold to Cust | Gross $ | Qty | Gross $ | Qty | Gross $ | Qty | Gross $ | Qty | Gross $ | Qty | Gross $ | Qty | Gross $ | Qty |
gear1 | Jacket blue | Walmart | 10215 | 10086 | 6884 | 14462 | 14723 | 6722 | 9773 | 10214 | 9885 | 14516 | 8659 | 7100 | 8172 | 6833 |
gear2 | Jacket Red | Target | 12941 | 9727 | 13301 | 7155 | 13887 | 13589 | 6292 | 14074 | 14025 | 6376 | 10083 | 7740 | 9466 | 9412 |
gear3 | Jacket Black | Bay | 14229 | 11919 | 9970 | 6011 | 10060 | 8979 | 12842 | 14102 | 8814 | 6640 | 14918 | 8440 | 6241 | 7059 |
How do I script this, I tried Crosstab option but periods and 2 measures making it difficult.
Thanks
Rashid
Maybe you can use this: multi_header_pivot_import.qvw