Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

shumailh
Contributor III

Display multiple fields on to X axes

I have the below grid in excel and i am loading it into my qlikview document. Also consider that i cannot change the format.

CategoryProductJan-09Feb-09Mar-09Apr-09May-09Jun-09
Category 1P13.713.853.9968714.144.2837424.43
Category 2P12.682.382.0803321.781.4806641.18
Category 3P20.070.080.08040.090.09080.10
Category 4P21.461.301.481.43981.451.52
Category 5P30.530.410.570.530.530.54
Category 6P314.314.5413.8914.313.4313.06
Category 7P48.167.317.518.167.627.05


Below is the code to load:


Business_Detail:
LOAD Category, Product,
[Jan-10] as Fee_Jan10,
[Feb-10] as Fee_Feb10,
[Mar-10] as Fee_Mar10,
[Apr-10] as Fee_Apr10,
[May-10] as Fee_May10,
[Jun-10] as Fee_Jun10,
[YTD Jun-10] as YTD_2010
FROM
[Business1.xls]


I want to make a line chart for the above grid where i want months to be on X axes. please help.

I try to transpose the data but it couldn't work with the two descriptive fields.

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Display multiple fields on to X axes

You need to use Crosstable load - it's part of the "Text Files" load wizard. You will have 2 qualifying fields - Category and Product.

6 Replies
MVP
MVP

Display multiple fields on to X axes

You need to use Crosstable load - it's part of the "Text Files" load wizard. You will have 2 qualifying fields - Category and Product.

shumailh
Contributor III

Display multiple fields on to X axes

Hi Oleg,

Which text file load wizard you are telling? I tried "table files" and tried all the options while transformation but not working. & how can i load excel file using text file load wizard?

Regards,
Shumail

syed_muzammil
Contributor II

Display multiple fields on to X axes

Hi,

When you load the Excel file using table wizard and press next then you can see the transform button . Press next again and you can see the CrossTable button on th top right corner.

shumailh
Contributor III

Display multiple fields on to X axes

I never use this option before, this is amazing... Thanks for the help Oleg and Muzammil.

shumailh
Contributor III

Display multiple fields on to X axes

Hi Oleg / Muzammil,

Now, one more issue I have when I use the cross table the date fields which were crossed is now showing as in number format Indifferent. see the snapshot. Any solution for this?

Regards,
Shumail Hussain

shumailh
Contributor III

Display multiple fields on to X axes

I got the simple solution Smile



=MonthName(Date(left(Fin_MnYr,5)))


Community Browser