Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Basic Graph problem....

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 :
ProductSales Jan 10Sales Feb 10Sales 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....
1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

2 Replies
Not applicable
Author

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

Kiran.

Not applicable
Author

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