Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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

1 Solution

Accepted Solutions
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

View solution in original post

11 Replies
Chanty4u
MVP
MVP

what error it is showing?

migueldelval
Specialist
Specialist

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

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

hi ,

its showing PnL not found

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

hi miguel,

The qvd is cease and the table is pnl.

migueldelval
Specialist
Specialist

Could you attach your script?

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

Hi PFA screenshots of the script

Chanty4u
MVP
MVP

instead of *

PnL:

load

Field1,

Field2

Filed3.....

From PNl .qvd

main:

load *,

field1

...

resident   PnL

migueldelval
Specialist
Specialist

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:

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

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;

Regards

Miguel del Valle

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

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)