topic Re: Why Inline Concat load is not saving? in QlikView

Why Inline Concat load is not saving?

Mon, 03 Dec 2012 16:35:07 GMT

See below code:

I reload the dashboard with the below code.

Save it, Close it, Reopen it

The Inline (0-DEMO SOLUTION PROVIDER) is not in the list of values for Solution Provider Name until I reload it again after I open.

Is this typical of inline loads? The issue is that it is not showing up on the version on AccessPoint after the morning reload.

SupplierSelectionTable:

Load distinct [VAR Reporting Name] as [Solution Provider Name]

resident VAR;

Concatenate

LOAD * INLINE [

Solution Provider Name

0-DEMO SOLUTION PROVIDER

];

Re: Why Inline Concat load is not saving?

shree909 — Mon, 03 Dec 2012 16:58:02 GMT

try like this

SupplierSelectionTable:

Load distinct [VAR Reporting Name] as [Solution Provider Name]

resident VAR;

Concatenate(SupplierSelectionTable)

LOAD * INLINE [

Solution Provider Name

0-DEMO SOLUTION PROVIDER

];

concatenate is a type of appending the date to the , table u will concat..

Re: Why Inline Concat load is not saving?

MayilVahanan — Mon, 03 Dec 2012 16:58:55 GMT

SupplierSelectionTable:

Load distinct [VAR Reporting Name] as [Solution Provider Name]

resident VAR;

Concatenate

(SupplierSelectionTable)

LOAD * INLINE [

"Solution Provider Name"

0-DEMO SOLUTION PROVIDER

];

Try like this

Re: Why Inline Concat load is not saving?

Mon, 03 Dec 2012 17:23:42 GMT

Thanks but still no luck. I may have to load from a file instead. i will test that and see if it works

Re: Why Inline Concat load is not saving?

Mon, 03 Dec 2012 17:51:41 GMT

well, I figured it out! Script fine! Section Access was the issue. Needed to add the value to the section access file. 🙂