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: 
mario-sarkis
Creator II
Creator II

Crosstable

hey all

i need to know how i can transform this form :

IDTrxCount
01Cash Deposits2509
01Check Out737
01CHI9
01CHP1499
01CHU232

into this form

IDCash DepositsCheck OutCHICHPCHU
01250973791499232

in the script

Thank you,

7 Replies
teiswamsler
Partner - Creator III
Partner - Creator III

Hi Mario

Look at this post, maybe it can help you.

crosstable reversed

/Teis

Clever_Anjos
Employee
Employee

This should work

LOAD

  ID,

  sum(if(Trx='Cash Deposits',Count)) as [Cash Deposits],

  sum(if(Trx='Check Out',Count)) as [Check Out],

  sum(if(Trx='CHI',Count)) as [CHI],

  sum(if(Trx='CHP',Count)) as [CHP],

  sum(if(Trx='CHU',Count)) as [CHU]

group by ID;

LOAD ID,

    Trx,

    Count

FROM

[https://community.qlik.com/thread/182932]

(html, codepage is 1252, embedded labels, table is @1);

MK_QSL
MVP
MVP

CrossTable (Name, Value)

Load * From YourTableName;

maniram23
Creator II
Creator II

Hi,

Try this one, it is helpful for you.

Generic

load * inline [

ID, Trx, Count

01, Cash Deposits, 2509

01, Check Out, 737

01, CHI, 9

01, CHP, 1499

01, CHU, 232

];

Not applicable

Hi

   use generic load.it may help

miguelbraga
Partner - Specialist III
Partner - Specialist III

Hey Gergy-sarkis,

Try this:

Table:
Generic LOAD * Inline [
ID, Trx, Count
01, Cash Deposits, 2509
01, Check Out, 737
01, CHI, 9
01, CHP, 1499
01, CHU, 232
]
;

To get this:

Sem Título.png

Miguel

mario-sarkis
Creator II
Creator II
Author

Thank you Teis this is exactly what i need:)