topic data view in QlikView

data view

Thu, 01 Mar 2012 10:57:35 GMT

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

data view

Anonymous — Thu, 01 Mar 2012 11:29:22 GMT

Sagar,

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

Regards,

Michael

data view

Thu, 01 Mar 2012 11:40:03 GMT

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

data view

Anonymous — Fri, 02 Mar 2012 11:22:41 GMT

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