Basic Graph problem....

[#1]

Hi,

I am new to Qlikview (using 9) and I have what seems to be a basic issue that drives me nuts not to manage to solve it alone...

I receive from finance a table like this :

Product	Sales Jan 10	Sales Feb 10	Sales March 10
1
2
goes on for 10000 rows

The file is in Excel and I can't obviously do a transpose of copy each colum as with 10k products + Sales since 2009 on a Monthly basis to which must be added budget numbers + actuals +++ It would take me days.

I guess that Developers in QlikView have thought of a very simple way to do a graph like this

x axis : Month

Y axis : Sales

Sales value being given as per product selection.

I manage to do it for 1 month, but I can't figure out how to put 2 or more months in the axis without creating a nightmare.

I attached a sample of the data....

[#2]

You have to a crosstable load from the excel and trasform it to a straight table. Enclosed the example.

Kiran.

[#3 · Accepted solution]

Thnaks the key word I was missing is Crosstable !

With your script and the keyword I managed to find the answer in the QlikView tutorial !! Lesson 21 for those interested.

Thanks

again