Help with Plotting of Aggregated data

[Sant]

Hi Qlik Community,

                                      I need to design a chart in Qlik Sense, which will have
X-axis : a Class
Y-axis : a numeric value-aggregation as per Class; 
( Bar chart but I don't need Bars )  more like a line plot but X-axis is not a continuous measure which Qlik would expect.

Kindly look at below image for my requirement.
I NEED to give freedom to end-user to filter 'Category' and that's why I'm not creating a Aggregated Table in Load Editor.

As a trade-off, I can do with Aggregated table but need help to generate a line plot from ~80 columns x 1 Row (Aggregated Table). Please do share some tips.

Thanks in Advance for help !

[vincent_ardiet_ · Accepted solution]

Maybe the easiest is to unpivot your table in the loading script.
See for example this statement:

test:
CrossTable (Class, Value)
load * inline
[Category, Class_A, Class_B, Class_C
White, 1, 2, 0
Blue, 9, 0, 4
Red, 5, 8, 0
Red, 0,5,6
White,8,7,2];

It will create 2 new fields [Class] and [Value] to obtain a table like this:

Category	Class	Value
White	Class_A	1
White	Class_B	2
White	Class_C	0
Blue	Class_A	9
...

[Sant]

Thanks a lot @vincent_ardiet_ 

Unpivoting using Crosstable command helped me to achieve desired visualizations.