Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

enfodavid
New Contributor III

Qlik Sense: Fill out table with key, or rather reducing rows

How do I fill out a table that has a key and all fields (Including some empty ones) but on separate rows. Desired table is just a row per key.

CHA.png

This is probably easy but I've drawn a total blank

1 Solution

Accepted Solutions
enfodavid
New Contributor III

Re: Qlik Sense: Fill out table with key, or rather reducing rows

Group By is what I'm looking for. I'm dumb

LOAD Only(%Key) as Key,

           Only(Field1) as Field1,

           Only(Field2) as Field1,

           Only(Field3) as Field1

FROM $Source

Group By %Key;

1 Reply
enfodavid
New Contributor III

Re: Qlik Sense: Fill out table with key, or rather reducing rows

Group By is what I'm looking for. I'm dumb

LOAD Only(%Key) as Key,

           Only(Field1) as Field1,

           Only(Field2) as Field1,

           Only(Field3) as Field1

FROM $Source

Group By %Key;

Community Browser