topic Re: Load certain data in QlikView

Load certain data

sculptorlv — Wed, 25 Nov 2020 16:16:04 GMT

Hello .. very simple quastion, which I can't solve by reading manual

I need to load manual certain data. Not from Excel, but just data.

I have 3 variable: A, B, C and I have to load 5 rows with data for each variable (=column) like:

A B C

1 5 7

4 6 8

5 7 9

4 6 7

Please help me with a syntaxis. Thank you in advance!!

Re: Load certain data

its_anandrjs — Tue, 01 Nov 2016 09:03:19 GMT

Hi,

You can create the simple inline table load in your Qlikview file it self

Ex:-

Load * Inline

[

A, B, C

1, 5, 7

4, 6, 8

5, 7, 9

4, 6, 7

];

By this you get 3 fields A,B and C and you can edit this table any time.

Regards,

Anand

Re: Load certain data

engishfaque — Tue, 01 Nov 2016 09:23:49 GMT

Hi Ruslans,

Use "First 5" before to Load statement such as given below,

First 5 //First 5 records will be loaded

Load * Inline

[

A, B, C

1, 5, 7

4, 6, 8

5, 7, 9

4, 6, 7

5, 5, 6

];

Kind regards,

Ishfaque Ahmed

Re: Load certain data

sculptorlv — Tue, 01 Nov 2016 09:48:40 GMT

If I want to use not numeric value, should I put brackets '' to it?

'values not numeris' ?

How I can put symbol [ to my not numeric values?

Re: Load certain data

its_anandrjs — Tue, 01 Nov 2016 09:54:27 GMT

Then try this

LOAD Text(A) as A, Text(B) as B, Text(C) as C ;

LOAD * INLINE [

A, B, C

1, 5, 7

4, 6, 8

5, 7, 9

4, 6, 7

5, 5, 6

];

Use Text function to convert value into the Text format for fields.

Regards,

Anand

Re: Load certain data

sculptorlv — Tue, 01 Nov 2016 10:01:35 GMT

Last quastion

How I can put symbol [ to my not numeric values?

Re: Load certain data

its_anandrjs — Tue, 01 Nov 2016 10:06:03 GMT

Can you please share any sample for the same.

Regards

Anand

Re: Load certain data

sculptorlv — Tue, 01 Nov 2016 10:08:03 GMT

I have the situation:

Load * Inline

[

Number, Description,

1, Apple[super]

]

How can I put [ bracket in my values?

Re: Load certain data

its_anandrjs — Tue, 01 Nov 2016 10:14:51 GMT

In the table is there only single line with this symbol [ ] or may be there are many symbols.

Explain full table and requirement please.

Regards

Anand

Re: Load certain data

sculptorlv — Tue, 01 Nov 2016 10:21:52 GMT

My main data are first two rows ..

I also want to make some correction by adding LOAD INLINE

but I can't use '[]' symbols in LOAD staitment

My current load is:

Load * Inline

[

Invntory_Journal_Nr, Journal_Order_Nr, Position_Nr, Location, Position_Description, Position_Measure_unit, Position_Cost, Position_Sell_Price, Quantity_System, Quantity_Calculated, Quantity_Difference

INV-001.01, V-201, 39385, 03T, Paletes INV, GAB, 1.675, 0, 0, 0, 20000

];

Re: Load certain data

tresB — Tue, 01 Nov 2016 10:22:29 GMT

Try like:

Load * Inline

Number, Description,

1, Apple[super]

" ;

Double quotes would be then considered as the INLINE start-end. Therefore, [] would be considered as part of your data.

Re: Load certain data

engishfaque — Tue, 01 Nov 2016 10:22:30 GMT

Hi Ruslans,

Here it is,

temp:

Load A, B, If(not IsNum(C), '[', C) as C Inline

[

A, B, C

1, 5, 7

4, 6, 8

5, 7, 9

4, 6, Apple

4, 6, 7

];

Kind regards,

Ishfaque Ahmed

Re: Load certain data

sculptorlv — Tue, 01 Nov 2016 10:24:07 GMT

Thank You!!

This is it!

Re: Load certain data

its_anandrjs — Tue, 01 Nov 2016 10:30:03 GMT

You can try this way.

Ex:-

LOAD Number, Replace( Replace(Description,'(','['),')',']') as Description;

Load * Inline

[

Number, Description

1, Apple(super)

2, Orange(super)

3, Lemon(Super)

];

Note:- Load your data with this symbol ( ) and the replace it by [ ].

Regards

Anand