Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharthsoam
Partner - Creator II
Partner - Creator II

how can i make a resident of a qvd

i have qvd named cease.qvd. In that there is a PnL table.

I am loading the PnL table from the qvd-

load * from [lib://pnl/cease.qvd] (qvd);

Then i want to make a resident table from PnL-

tab2:

Load

"Fiscal Year",

Quarters,

"Customer Group Descr",

SBU_leaders,

If(((sum(EBIDTA)/sum(new_revenue))*100)<0,'<0%',

If(((sum(EBIDTA)/sum(new_revenue))*100)>=0 and (sum(EBIDTA)/sum(new_revenue))*100<10,'0-10%',

If(((sum(EBIDTA)/sum(new_revenue))*100)>=10 and (sum(EBIDTA)/sum(new_revenue))*100<20,'10-20%',

If(((sum(EBIDTA)/sum(new_revenue))*100)>=20,'>=20%','<0%')))) as EBIDTA%_categorization

Resident PNL  //??

Group by "Fiscal Year",Quarters,"Customer Group Descr",SBU_leaders;

If i try making a resident of PnL it is showing me a an error. , how can i make a resident by loading the qvd with the above script.

New to making qvd's, request your help

11 Replies
migueldelval
Specialist
Specialist

Hi,

Follow this steps for example.

One --> name:

                Load Table1 from excel

Two --> Concatenate

               Load Table2 from excel

Three --> Store name into .../name.Qvd.

               Drop Table name;


-------------> You don´t need to make this if you don´t change of app.


Four --> name:

               Load * FROM .../.nameQVD (QVD);

             

               name2: Load * Resident name;

--------------> Take care with sythetics

Regards

Miguel del Valle

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

also if i store 2 tables in a qvd , i want all the columns of table1 to load . How can i achieve this via load statement

much thanks:)