Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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:)