Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create Crosstable with resident table

Hallo,

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

Little example:

This format :

SerialDate
S111-05-2013
S203-05-2013
S107-02-2013
S111-05-2013
S310-05-2013
S209-05-2013
S301-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


S1





1


2
S2

1




1

S31







1

?

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

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand
Not applicable
Author

How would the statement look, if i use resident?