Load Inline

[#1]

Wondered whether someone could possibly help with a query?  I have loaded some data into the script editor using the load inline method but only two of the metrics are appearing as an option for charts to link to.  Does anyone know why this might be?  The script is setup in the following way:

LOAD * INLINE [

    Metric, YTD

    Test 1, 89.8%

];

LOAD * INLINE [

    Metric, YTD

    Test 2, 95.5%

];

LOAD * INLINE [

    Metric, YTD

    Test 3, 96.2%

];

LOAD * INLINE [

    Metric, YTD

    Test 4, 85.5%

];

[Chanty4u]

yes.. it will take as  single table .. as field names are same [ Metric ,YTD]

so u can give other names to  lik [ Metric1 -4   ,  YTD1-4]

and try

LOAD * INLINE [

    Metric, YTD

    Test 1, 89.8%

];

LOAD * INLINE [

    Metric1, YTD1

    Test 2, 95.5%

];

LOAD * INLINE [

    Metric2, YTD2

    Test 3, 96.2%

];

LOAD * INLINE [

    Metric3, YTD3

    Test 4, 85.5%

];

[sunny_talwar]

2 metric are  appearing? Which 2?

[jonathandienst]

I don't understand your problem, but you can simplify that script:

LOAD * INLINE [

    Metric, YTD

    Test 1, 89.8%

    Test 2, 95.5%

    Test 3, 96.2%

    Test 4, 85.5%

];

I suggest that you post a sample document illustrating the problem.

[martinpohl]

see help:

Concatenating tables ‒ Qlik Sense

Automatic concatenation

If the field names and the number of fields of two or more loaded tables are exactly the same, Qlik Sense will automatically concatenate the content of the different statements into one table.

Regards