Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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 postSmiley Happy

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

Re: Create Crosstable with resident table

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

Re: Create Crosstable with resident table

XD to cripple it^^

I suspected that answearSmiley Wink

Thank u anywaySmiley Happy

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

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

Re: Create Crosstable with resident table

How would the statement look, if i use resident?

Community Browser