topic Re: Create Crosstable with resident table in QlikView

Create Crosstable with resident table

Tue, 25 Jun 2013 13:27:02 GMT

Hallo,

is it possible to create a crosstable using a resident table?

Little example:

This format :

Serial	Date
S1	11-05-2013
S2	03-05-2013
S1	07-02-2013
S1	11-05-2013
S3	10-05-2013
S2	09-05-2013
S3	01-05-2013

to this one:

Serial

01-05-2013

02-05-2013

03-05-2013

04-05-2013

05-05-2013

06-05-2013

07-05-2013

08-05-2013

09-05-2013

10-05-2013

11-05-2013

You didn't have to explain it, if there is an other post wich does so...

But i cant find anything about and would also be happy if u give me the link to this post:)

And there is no use in defining every column, because in the end the time interval will be over several years.

And i dont want to define more than 365 days^^

Thx

Sarah

Re: Create Crosstable with resident table

Gysbert_Wassenaar — Tue, 25 Jun 2013 13:32:08 GMT

If you really want to cripple your data model you can use Generic load. See the help file for details.

Data:

Generic

LOAD *, 1 as Counter INLINE [

Serial, Date

S1, 11-05-2013

S2, 03-05-2013

S1, 07-02-2013

S1, 11-05-2013

S3, 10-05-2013

S2, 09-05-2013

S3, 01-05-2013

];

Otherwise leave the data as it is and use a pivot table to show the data as a crosstable.

Re: Create Crosstable with resident table

Tue, 25 Jun 2013 13:44:32 GMT

XD to cripple it^^

I suspected that answear;)

Thank u anyway:)

But i have to define every date?

There's no possibility to cripple it automatically, mean any QV function?

And yes, if i can i try to avoid using this. But i have some "self animated" charts using crosstables and i dont want to create them with Excel any longer:/

This will only be used for some special chart, where i didn't find a solution to avoid using crosstables.

Re: Create Crosstable with resident table

Gysbert_Wassenaar — Tue, 25 Jun 2013 13:54:09 GMT

The inline is just an example, you can use a resident load instead. See attached example. It has a pivot table based on the original data format and two straight tables using the exploded data from the Generic load. My advise is to not do a generic load and use the pivot table instead to show the data in that layout.

Re: Create Crosstable with resident table

Tue, 25 Jun 2013 14:20:30 GMT

How would the statement look, if i use resident?