topic Re: Load a QlilKView straight table into the script in QlikView

Load a QlilKView straight table into the script

andyrebs — Wed, 01 Apr 2015 17:39:37 GMT

Hello,

I hope this is not a stupid question.

Is it possible to load into the script a table present in the same Application?

Thanks

Best regards

Andrea

Re: Load a QlilKView straight table into the script

sunny_talwar — Wed, 01 Apr 2015 17:45:31 GMT

You can extract the table into Excel and load it into the application, but not entirely sure if you can load a straight table inside the application into the same application.

Best,

Sunny

Re: Load a QlilKView straight table into the script

ziadm — Wed, 01 Apr 2015 18:10:24 GMT

You can include inline load statement in your script to load a data typed in the script. I think that there are no limitation on number of records

However, you may copy from excel sheet the data and paste it into your script having the load * Inline statement preceding the data

LOAD * INLINE [

F1, F2, F3

1, A, A

2, B, C

3, D, F

];

Re: Load a QlilKView straight table into the script

andyrebs — Thu, 02 Apr 2015 12:56:46 GMT

Dear All,

thank you for your answers,

I appreciate your suggestions to extract the table into excel or copy from a excel sheet.

Actually I was asking an automatic system to load a straight table without any manual proceeding.

Any other solutions?

Re: Load a QlilKView straight table into the script

ziadm — Thu, 02 Apr 2015 18:49:04 GMT

Your question is not clear

you may load data from any external DB or Text files.

May be you are referring to resident load. Which means you already have the table loaded from external DB or Text and we want to load it into different table. if this is the case, this is called resident load.

Table2:

LOAD

Product,

Group,

[Sale Price]

Resident Table1;

Re: Load a QlilKView straight table into the script

sunny_talwar — Thu, 02 Apr 2015 20:27:48 GMT

Hi Ziad,

I think all he is looking for a way to dynamically load data from a straight table from a qvw to its own script. I don't see why anyone would do that, but that is what he is trying to accomplish here.

Best,

Sunny

Re: Load a QlilKView straight table into the script

andyrebs — Sat, 04 Apr 2015 10:16:09 GMT

hi Sunny

thanks to have understood my question. The reason why I am looking to load data from a straight table is that the expressions in the table are connected to each other and it would be easier load the results of these expressions instead do a more complicated formula. I know there should be another solution, using different functions, but it is impossible to explain what I am looking for without show my data and I can't do that.

In any case it seems there is no possibility to load a straight table dynamically.

Thanks

ps.

In Italy Andrea is a male name

Re: Load a QlilKView straight table into the script

sunny_talwar — Sat, 04 Apr 2015 11:43:40 GMT

Andrea,

My heart felt apologies. I have never came across a guy with that name and in my shortsightedness I did not think that Andrea could be a guy's name.

Best,

Sunny

Re: Load a QlilKView straight table into the script

Anonymous — Sat, 04 Apr 2015 11:50:33 GMT

Hi Andrea,

you can implement the same logic which you have used in the straight table in Qlikview script with resident load

with if else analysis instead of set analysis for aggregation and then group by for dimensions

note: you will have to join the tables in case you are adding fields from different tables in dimension of straight table.

because resident is possible only on single table.

I totally agree that the aggregation on front end charts is quite faster than the time is takes at the script level.

but unfortunately there is no way to pull the straight table level data in qv script

Re: Load a QlilKView straight table into the script

andyrebs — Tue, 14 Apr 2015 11:01:06 GMT

Hi Bhagirath

thank you for your answer. I am sorry for the delay in answering you but I was away for a business trip.

I understand the concept of your solution, but I have never used the resident load in this way. Might you send me a script as a sample, so that I can complete it with my datas?

Thanks

Andrea