Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
i have a simple question about CrossTable() function.
i have excel file starting. JAN, FEB MAR, APR.
if i am using crosstable(Month, Data), starting from 1, default is 1.
if i am using crosstable(Month, Data,1), it start from FEB, Showing Jan as a SEPRATES Field,
if i am using crosstable(Month, Data,0), IT DOES NOT WORK.
How to read the Jan column..
Regards
Khan
With the crosstable prefix, you always need a key that links the values of the different data columns. Otherwise QlikView will not be able to track which initial row the value belongs to. In your case you do not have such a key, so you need to create one.
Try
Crosstable (Month, Data)
Load
recno() as Key,
Jan,
Feb, ...
HIC
With the crosstable prefix, you always need a key that links the values of the different data columns. Otherwise QlikView will not be able to track which initial row the value belongs to. In your case you do not have such a key, so you need to create one.
Try
Crosstable (Month, Data)
Load
recno() as Key,
Jan,
Feb, ...
HIC
Thank you so much..
its working..
But if,
for example i have 10 coulmns, and i want to use crosstable 1 to 5, and others 5 i want to load as it is.
so how can we control the right side.
eg, 2005, 2006,2007,2008,2009, SALESREP, REGION. SO ON.
Kind Regards
Khan.