data view

[#1]

Hello Guys

Need your help

I have a table in DB which I already imported in QV. Now, my problem is that-- the table have values in different columns(jan--dec) and i want to plot the chart such that X-axis will have values from Jan to Dec. Note(there is no column for time/date in my table). Kindly help me in this

Regards

Sagar

[Anonymous]

Sagar,

Hint - use crosstable to convert columns jan to dec into one column (month) with values jan to dec.

Regards,

Michael

[#3]

Hi Michael,

Thanks for your help

But i really doubt that doing this can screw my data as the data have 98 columns and 588513 rows. If I am doing this do i need to change the remaining columns which are my drilldowns.

Regards

Sagar Gupta

[Anonymous]

Sagar,

The number of fields shouldn't be a problem by itself.  The order of fields does matter though.  See an example where there are two fields in the beginning that you want to keep.  In your case will be a larger number.

table1:

crosstable (month, amount, 2)
LOAD * INLINE [
id_customer, Payer, jan, feb, mar 
a,    b,  12,  5,  4
a,    c,  2,  1,  3
z,    c,  10,  5,  4
z,    b,  10,  7,  3
r,    e,  10,  8,  6
r,    b,  10,  5,  4
r,    d,  10,  6,  2
];

Also you can think of the separating month/amount fields plus one more link field into a separate logical table, if it makes sense in your application.

Regards,
Michael