Crosstable using a load resident

Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I need to do a crosstable on a table that I already have in my app. Is it possible to do so using a load resident? If not, how should I do it?

Re: Crosstable using a load resident

MindaugasBacius — Thu, 07 Jul 2016 05:21:26 GMT

You can do this:

Table:
Load *
Inline [
ID, 2016-01-01, 2016-01-02
1, A, 
2, B, C
3, , D
];


Table2:
CrossTable(Date, Data)
LOAD ID as Iden, 
     [2016-01-01], 
     [2016-01-02]
Resident Table;

And the result would be like:

topic Crosstable using a load resident in QlikView

Crosstable using a load resident

Re: Crosstable using a load resident