Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
mayankraoka
Valued Contributor

bundle info load issue

Hi All,

I am trying to load the country flags with the bundle load function.The Images are getting loaded properly of all the countries ,But the Problem I am facing is that the bundle oad function will not work with left join.Due to which the unwanted country data is also visible.

Lets take an example:

I have sales data foe 100 countries.The flag excel sheet have 150 countries. On the basis of country selection there flag images should get display that is the requirement. The Images are getting displayed correctly but the in the country list box I am getting other extra countries list also which i dont want to get displayed.

To solve this i tried  to use left join but it wont work with bundle info load.

Can anyone help me on this.

Please let me know in case you required anything.

Regards,

Mayank

1 Solution

Accepted Solutions

Re: bundle info load issue

May be this since you are applying Upper transformation to the field:

LOAD  UPPER(Item) as COUNTRY,

     [File name],

     Location,

     Image as Flags ,

     F5

FROM

[..\Images\Country Flags\map1.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where Exists (COUNTRY, Upper(Item));

View solution in original post

7 Replies

Re: bundle info load issue

Not sure if Left Keep will work either, but give it a short.

Re: bundle info load issue

You can also try Where Exists()

MVP & Luminary
MVP & Luminary

Re: bundle info load issue

Maybe you made your filter one step before and apply then the bundle load. An alternatively might be to exists() for the filtering - see: The exists issue

- Marcus

mayankraoka
Valued Contributor

Re: bundle info load issue

Thanks sunny for quick reply.

But where exists i tried it is not working .Please check the below syntax am I making any mistake?The Sales_Jul table has COUNTRY column and only that Countries I want to display in app.

LEFT KEEP (Sales_Jul)

LOAD  UPPER(Item) as COUNTRY,

     [File name],

     Location,

     Image as Flags ,

     F5

FROM

[..\Images\Country Flags\map1.xlsx]

(ooxml, embedded labels, table is Sheet1) where exists (COUNTRY,Item);

Regards,

Mayank

Re: bundle info load issue

May be this since you are applying Upper transformation to the field:

LOAD  UPPER(Item) as COUNTRY,

     [File name],

     Location,

     Image as Flags ,

     F5

FROM

[..\Images\Country Flags\map1.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where Exists (COUNTRY, Upper(Item));

View solution in original post

mayankraoka
Valued Contributor

Re: bundle info load issue

Hi Sunny,

Thank you very much Sunny ,This solves my issue.

Thanks once again.

Regards,

Mayank

Re: bundle info load issue

Not a problem