Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new in qlikview. I want to know about cross table.tell me some idea about cross table....send me a qvw file.
TempBudget:
CrossTable(TempMonth,BudgetValue,2)
Load * Inline
[
Item Code, Item Desc, M1, M2, M3, M4, M5, M6, M7, M8, M9, M10, M11, M12
A1, Tiles, 12, 143, 56, 780, 623, 71, 64, 78, 54, 54, 81,10
A2, Geyser, 15, 154, 543, 721, 643, 64, 87, 09, 987, 09, 76,43
A3, Taps, 19, 15, 182, 765, 661, 71, 63, 87, 909, 81, 91,61
A4,Mixers, 81, 151, 55, 81, 451, 61, 71, 61, 41, 51, 85,98
A5, Tubs, 15, 154, 543, 721, 643, 64, 87, 09, 987, 09, 76,43
];
TempBudget:
CrossTable(TempMonth,BudgetValue,2)
Load * Inline
[
Item Code, Item Desc, M1, M2, M3, M4, M5, M6, M7, M8, M9, M10, M11, M12
A1, Tiles, 12, 143, 56, 780, 623, 71, 64, 78, 54, 54, 81,10
A2, Geyser, 15, 154, 543, 721, 643, 64, 87, 09, 987, 09, 76,43
A3, Taps, 19, 15, 182, 765, 661, 71, 63, 87, 909, 81, 91,61
A4,Mixers, 81, 151, 55, 81, 451, 61, 71, 61, 41, 51, 85,98
A5, Tubs, 15, 154, 543, 721, 643, 64, 87, 09, 987, 09, 76,43
];
HIC