topic Re: bundle info load issue in QlikView

bundle info load issue

mayankraoka — Thu, 21 Jan 2016 09:07:38 GMT

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

Re: bundle info load issue

sunny_talwar — Thu, 21 Jan 2016 10:13:11 GMT

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

Re: bundle info load issue

sunny_talwar — Thu, 21 Jan 2016 10:13:37 GMT

You can also try Where Exists()

Re: bundle info load issue

marcus_sommer — Thu, 21 Jan 2016 10:15:28 GMT

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

Re: bundle info load issue

mayankraoka — Thu, 21 Jan 2016 10:17:16 GMT

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 ,

FROM

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

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

Regards,

Mayank

Re: bundle info load issue

sunny_talwar — Thu, 21 Jan 2016 10:18:50 GMT

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

LOAD UPPER(Item) as COUNTRY,

[File name],

Location,

Image as Flags ,

FROM

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

(ooxml, embedded labels, table is Sheet1)

Where Exists (COUNTRY, Upper(Item));

Re: bundle info load issue

mayankraoka — Thu, 21 Jan 2016 10:32:41 GMT

Hi Sunny,

Thank you very much Sunny ,This solves my issue.

Thanks once again.

Regards,

Mayank

Re: bundle info load issue

sunny_talwar — Thu, 21 Jan 2016 10:33:15 GMT

Not a problem