Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
tincholiver
Creator III
Creator III

cross table

hi everyone,

I don´t know how solve this:

 

mi table:

DATECARQuant
202107AUDI4
202107HONDA9
202107FORD129
202108AUDI3
202108HONDA7
202108FORD116

 

mi desired table:

DATEAUDIHONDAFORD
20210748129
20210837119

 

ideas? thank a lot

1 Solution

Accepted Solutions
Saravanan_Desingh

Try this,

tab1:
Generic
LOAD * INLINE [
    DATE, CAR, Quant
    202107, AUDI, 4
    202107, HONDA, 9
    202107, FORD, 129
    202108, AUDI, 3
    202108, HONDA, 7
    202108, FORD, 116
];

commQV04.PNG

View solution in original post

4 Replies
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hi, 

You'll have to use separate measure for each CAR in straight table.

Measure for AUDI : Sum({<CAR = {"AUDI"}>}Quant)

and 2 more for other Cars.

AshutoshBhumkar_0-1632583408599.png

Or you can use Pivot table :

AshutoshBhumkar_1-1632583522215.png

Thanks,

Ashutosh

tincholiver
Creator III
Creator III
Author

hi @AshutoshBhumkar 

i need to load desired table in script not in graph

Saravanan_Desingh

Try this,

tab1:
Generic
LOAD * INLINE [
    DATE, CAR, Quant
    202107, AUDI, 4
    202107, HONDA, 9
    202107, FORD, 129
    202108, AUDI, 3
    202108, HONDA, 7
    202108, FORD, 116
];

commQV04.PNG

tincholiver
Creator III
Creator III
Author

thanks @Saravanan_Desingh 

works perfect!!