topic Re: Can we store inline as QVD? in QlikView

Can we store inline as QVD?

Anonymous — Mon, 27 Oct 2014 10:37:56 GMT

Hi,

I have a scenario where i should not do any hardcoding ,so my lead told me to make inline as an excel file and store it as a qvd.

Wondering is that a good practice or any suggestions pls.

Regards,

Sharma.

Re: Can we store inline as QVD?

alexandros17 — Mon, 27 Oct 2014 10:40:52 GMT

If you need to do .... Yes and all data can be saved as qvd ...

Re: Can we store inline as QVD?

its_anandrjs — Mon, 27 Oct 2014 10:41:41 GMT

Yes you can try with

Country:

Load * inline

[

Country

India

America

China

];

Store Country into Country.qvd; //And store it as the QVD

But i am not understand means of inline as an excel

Regards,

Anand

Re: Can we store inline as QVD?

Mon, 27 Oct 2014 11:00:31 GMT

Hi,

First you need to create a inline table like this

Table:

Load * inline[

FieldName

Value1

Value2

Value3

];

Store Table into Table.qvd(qvd);

Re: Can we store inline as QVD?

ashfaq_haseeb — Mon, 27 Oct 2014 11:03:17 GMT

Hi,

may be like this.

Have a look at attached application

Regards

ASHFAQ

Re: Can we store inline as QVD?

Anonymous — Mon, 27 Oct 2014 14:26:49 GMT

Thanks Asfaq,

That is what i wanted. And also if some one wants to add anything in furute , they can still add the records in inline excel and we can load it as qvd right??

Regard,

Sharma

Re: Can we store inline as QVD?

ashfaq_haseeb — Mon, 27 Oct 2014 17:32:21 GMT

Yes,

You are right.

Regards

ASHFAQ