topic Re: Fill Cross Table in QlikView

Fill Cross Table

cristian_av — Wed, 25 Nov 2020 16:16:04 GMT

I have data with the following format:

Role User

Admin User1

Admin User2

Admin User3

Role2 User2

....

And I need to create a Table like this:

Wich expression should I use in my table?

I've tried with "=1", but it puts a 1 in all the records, so it's useless.

Thanks!!

marcus_sommer — Tue, 07 Mar 2017 15:02:40 GMT

Try it with: count(User)

- Marcus

german24 — Tue, 07 Mar 2017 15:10:19 GMT

Hi,

try this...

Best regards,

German

el_aprendiz111 — Tue, 07 Mar 2017 16:10:33 GMT

Hi,

DATA:
LOAD *, 1 AS COUNT;
LOAD * Inline
[
Role,User
Admin,User1
Admin,User2
Admin,User3
Role2,User2
];
EXIT Script;