11 Replies Latest reply: Jun 18, 2018 7:51 AM by siddharth soam

# how can i make a resident of a qvd

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

Then i want to make a resident table from PnL-

tab2:

"Fiscal Year",

Quarters,

"Customer Group Descr",

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

• ###### Re: how can i make a resident of a qvd

what error it is showing?

• ###### Re: how can i make a resident of a qvd

What is the name of first table, when you load a "PNL QVD"?

• ###### Re: how can i make a resident of a qvd

hi miguel,

The qvd is cease and the table is pnl.

• ###### Re: how can i make a resident of a qvd

hi ,

• ###### Re: how can i make a resident of a qvd

Hi PFA screenshots of the script

• ###### Re: how can i make a resident of a qvd

PnL:

Field1,

Field2

Filed3.....

From PNl .qvd

main:

field1

...

resident   PnL

• ###### Re: how can i make a resident of a qvd

Hi,

I think that you nedd to name your table when you load QVD. If you have another table with the same name, You are going to have problems too.

PNL:

tab2:

"Fiscal Year",

Quarters,

"Customer Group Descr",

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;

Regards

Miguel del Valle

• ###### Re: how can i make a resident of a qvd

Hi Miguel/Chanty,

I have 2 different tables having almost the same colmuns being loaded from two different sources which i merged in a single qvd(cease)

• ###### Re: how can i make a resident of a qvd

Hi,

One --> name:

Two --> Concatenate

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:

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

Regards

Miguel del Valle

• ###### Re: how can i make a resident of a qvd

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:)