topic Re: Populate Table Dinamically in QlikView

Populate Table Dinamically

marcel_olmo — Fri, 13 Nov 2015 13:53:46 GMT

Hi guys,

I have a table like this :

A list of possible SubGroups like this :

And I'd like to populate the blank fields of the Subgroup Column with the possible Subgroup values not populated before (blank means all possible values except the ones that were previously populated). This is my desired result :

How can I do it with Qlik? Anyone can give me some help with that?

I've attached an example here.

Regards, Marcel.

Re: Populate Table Dinamically

maxgro — Fri, 13 Nov 2015 14:59:48 GMT

Tmp:

load distinct Year, Month, Group, Reference

FROM Example.xlsx (ooxml, embedded labels, table is Hoja1);

join(Tmp)

LOAD SubGroup

FROM Example.xlsx (ooxml, embedded labels, table is Hoja2);

left join (Tmp)

load Year, Month, Group, Reference, SubGroup, Amount

FROM Example.xlsx (ooxml, embedded labels, table is Hoja1);

left join (Tmp)

load Year, Month, Group, Reference, Amount as Amount2

FROM Example.xlsx (ooxml, embedded labels, table is Hoja1)

where len(trim(SubGroup))=0;

Final:

load Year, Month, Group, SubGroup, Reference, alt(Amount, Amount2) as Amount

Resident Tmp;

DROP Table Tmp;

Re: Populate Table Dinamically

marcel_olmo — Mon, 16 Nov 2015 09:14:23 GMT

Thanks Maxgro! It works like a charm.

Regards, Marcel.