topic Re: On-demand App Generation(ODAG) in QlikSense Issue in App Development

On-demand App Generation(ODAG) in QlikSense Issue

akshaye_c_navale — Wed, 26 Jun 2019 18:09:32 GMT

Hi Team,

I have created ODAG Selection Application & Detail Application in Qlik Sense.

I am facing one issue when i am navigating from Selection App to Detail App then some of Fields values are not get passed to Detail App from Selection App where fields contains commas (,).

Due to this data is not matching in Selection & Detail App.

Could you please help on this.

Thanks,

Akshay

Re: On-demand App Generation(ODAG) in QlikSense Issue

vijetas42 — Fri, 11 Jan 2019 08:09:42 GMT

can you post sample data and code that how you are passing field values

Regards,

Vijeta

Re: On-demand App Generation(ODAG) in QlikSense Issue

akshaye_c_navale — Fri, 11 Jan 2019 10:27:36 GMT

Hi ,

I have written below code in Detail App Template :

SET DEPL_GEO_UNIT = $(odso_Depl Geo Unit);
OdagBinding:
LOAD * INLINE [
VAL
$(odso_Depl Geo Unit){"quote": "", "delimiter": ""}
];
SET [DEPL_GEO_UNIT_COLNAME] = 'Depl Geo Unit';
CALL BuildValueList('DEPL_GEO_UNIT', 'OdagBinding','VAL', 39);

The Depl Geo Unit Field contains value like India;Japan;USA;UK, Ireland.

but UK, Ireland is passed as UK only.

I have seen this issue with Comma only.

Thanks,

Akshay

Re: On-demand App Generation(ODAG) in QlikSense Issue

akshaye_c_navale — Fri, 11 Jan 2019 10:29:09 GMT

Hi Vijeta,

I have written below code in Detail App Template :

SET DEPL_GEO_UNIT = $(odso_Depl Geo Unit);
OdagBinding:
LOAD * INLINE [
VAL
$(odso_Depl Geo Unit){"quote": "", "delimiter": ""}
];
SET [DEPL_GEO_UNIT_COLNAME] = 'Depl Geo Unit';
CALL BuildValueList('DEPL_GEO_UNIT', 'OdagBinding','VAL', 39);

The Depl Geo Unit Field contains value like India;Japan;USA;UK, Ireland.

but UK, Ireland is passed as UK only.

I have seen this issue with Comma only.

Thanks,

Akshay

Re: On-demand App Generation(ODAG) in QlikSense Issue

vijetas42 — Fri, 11 Jan 2019 11:09:18 GMT

so, in your original valuelist 'India;Japan;USA;UK, Ireland' can't you make it consistent delimiter. because the issue is only of that.

Re: On-demand App Generation(ODAG) in QlikSense Issue

akshaye_c_navale — Fri, 11 Jan 2019 12:11:20 GMT

No, actually we can't modify value as its our master data.
The below code creates list of values in Inline table
OdagBinding:
LOAD * INLINE [
VAL
$(odso_Depl Geo Unit){"quote": "", "delimiter": ""}
];

We need to enclosed values in " quotes , but however i used quote & delimiter properties but those not working after i tried.