topic Re: List Box in QlikView

List Box

rathnam_qv — Fri, 25 Oct 2013 06:46:51 GMT

Hi all,

i have Region field in 5 tables..when i selected one region 0field from one table as a list box the chart which is created from that perticular table is getting populated.

Remaining charts are not....

Any solution for this...

Thanks in advance!!!

Smiley

Re: List Box

vikasmahajan — Fri, 25 Oct 2013 06:56:30 GMT

Hii

This means region Field is not linked in your data model , you need to link it for affection of all the 5 tables.

Vikas

Re: List Box

rathnam_qv — Fri, 25 Oct 2013 07:00:32 GMT

Hi Vikas,

but i am using Trasanctional level Data...no Schema and no predefined keys also

Smiley

Re: List Box

jagan — Fri, 25 Oct 2013 07:02:21 GMT

Hi,

Create a link table for Region and link all other tables to this table.

RegionLinkTable:

LOAD

Region

FROM Table1;

Concatenate(RegionLinkTable)

LOAD

Region

FROM Table2;

Concatenate(RegionLinkTable)

LOAD

Region

FROM Table5;

Hope this helps you.

Regards,

Jagan.

Re: List Box

kaushalview — Fri, 25 Oct 2013 07:46:35 GMT

Hi,

Can you share your application?

Regards

Kaushal Meha

Re: List Box

rathnam_qv — Fri, 25 Oct 2013 09:17:49 GMT

Thanks Jagan

Re: List Box

Fri, 25 Oct 2013 09:31:57 GMT

Try having the same field for all your charts the result must populate. if so then create an seperate dimension for the same and add the id's to the fact table

Thanks,

Shyam