Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am having one scenario that,I have to show some image in list box.When am pulling that image did not showing any image in qvw.I am using bundle info only to pull the data.So any of you have came across this kind of issue please let me know how to fix....
Thanks & Regards
Jai
Hi Jai,
I use below code in one of my file with success:
forecast_conditions:
LOAD [condition/data],
[icon/data],
[icon/data] as ForeCastImg, //Key
[high/data],
[low/data],
[day_of_week/data],
%Key_xml_api_reply_5B90566A772C5AA3 // Key to parent table: xml_api_reply
FROM [http://www.google.com/ig/api?weather=Copenhagen&hl=en] (XmlSimple, Table is [xml_api_reply/weather/forecast_conditions]);
xml_api_reply:
LOAD version,
[weather/module_id] as module_id,
[weather/tab_id] as tab_id,
[weather/mobile_row] as mobile_row,
[weather/mobile_zipped] as mobile_zipped,
[weather/row] as row,
[weather/section] as section,
[weather/current_conditions/wind_condition/data] as [wind_condition/data],
[weather/current_conditions/icon/data] as [current_conditions/icon/data],
[weather/current_conditions/humidity/data] as [humidity/data],
[weather/current_conditions/temp_c/data] as [temp_c/data],
[weather/current_conditions/temp_f/data] as [temp_f/data],
[weather/current_conditions/condition/data] as [current_conditions/condition/data],
[weather/forecast_information/unit_system/data] as [unit_system/data],
[weather/forecast_information/current_date_time/data] as [current_date_time/data],
[weather/forecast_information/forecast_date/data] as [forecast_date/data],
[weather/forecast_information/postal_code/data] as [postal_code/data],
[weather/forecast_information/city/data] as [city/data],
%Key_xml_api_reply_5B90566A772C5AA3 // Key for this table: xml_api_reply
FROM [http://www.google.com/ig/api?weather=Copenhagen&hl=en] (XmlSimple, Table is [xml_api_reply]);
CurrentImages:
BUNDLE INFO LOAD
[weather/current_conditions/icon/data] as Current_Image,
'http://www.google.com'&[weather/current_conditions/icon/data] as Current_Path
FROM [http://www.google.com/ig/api?weather=Copenhagen&hl=en] (XmlSimple, Table is [xml_api_reply]);
ForeCastImages:
BUNDLE INFO LOAD
[icon/data] as ForeCastImg,
'http://www.google.com'&[icon/data] as ForecastPath
FROM [http://www.google.com/ig/api?weather=Copenhagen&hl=en] (XmlSimple, Table is [xml_api_reply/weather/forecast_conditions]);
Hi ASIM,
Thanks for your kind reply.I hope for your qvw it is pulling data directly from online.In that case it is fine.
Now I want to fetch th data which is availble as offline.On that case how should data should be.Please share me with some model data source file,even as xls.It would be greatful for me.
Thanks & Regards
Jai
Hi Jai,
If you want to use offline pictures I can suggest you to use below example:
http://community.qlik.com/media/p/84134/download.aspx
I think It would be useful for you.
Best Regards,
Asim Akin