topic Re: Crosstable in QlikView

Crosstable

mario-sarkis — Mon, 28 Sep 2015 11:54:10 GMT

hey all

i need to know how i can transform this form :

ID	Trx	Count
01	Cash Deposits	2509
01	Check Out	737
01	CHI	9
01	CHP	1499
01	CHU	232

into this form

ID	Cash Deposits	Check Out	CHI	CHP	CHU
01	2509	737	9	1499	232

in the script

Thank you,

Re: Crosstable

teiswamsler — Mon, 28 Sep 2015 11:59:12 GMT

Hi Mario

Look at this post, maybe it can help you.

crosstable reversed

/Teis

Re: Crosstable

Clever_Anjos — Mon, 28 Sep 2015 12:01:01 GMT

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);

Re: Crosstable

MK_QSL — Mon, 28 Sep 2015 12:08:24 GMT

CrossTable (Name, Value)

Load * From YourTableName;

Re: Crosstable

maniram23 — Mon, 28 Sep 2015 15:39:10 GMT

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

];

Re: Crosstable

Mon, 28 Sep 2015 16:00:02 GMT

use generic load.it may help

Re: Crosstable

miguelbraga — Mon, 28 Sep 2015 16:37:50 GMT

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:

Miguel

Re: Crosstable

mario-sarkis — Tue, 29 Sep 2015 05:48:35 GMT

Thank you Teis this is exactly what i need:)