Load a QlilKView straight table into the script

[andyrebs]

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

[sunny_talwar]

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

[ziadm]

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

];

[andyrebs]

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?

[ziadm]

Hi

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;

[sunny_talwar]

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

[andyrebs]

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

BR

ps.

In Italy Andrea is a male name

[sunny_talwar]

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

[Anonymous]

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

[andyrebs]

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