Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharthsoam
Contributor

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
Valued Contributor

Re: how can i make a resident of a qvd

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

11 Replies
sureshqv
Esteemed Contributor III

Re: how can i make a resident of a qvd

what error it is showing?

migueldelval
Valued Contributor

Re: how can i make a resident of a qvd

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

siddharthsoam
Contributor

Re: how can i make a resident of a qvd

hi ,

its showing PnL not found

siddharthsoam
Contributor

Re: how can i make a resident of a qvd

hi miguel,

The qvd is cease and the table is pnl.

migueldelval
Valued Contributor

Re: how can i make a resident of a qvd

Could you attach your script?

siddharthsoam
Contributor

Re: how can i make a resident of a qvd

Hi PFA screenshots of the script

sureshqv
Esteemed Contributor III

Re: how can i make a resident of a qvd

instead of *

PnL:

load

Field1,

Field2

Filed3.....

From PNl .qvd

main:

load *,

field1

...

resident   PnL

migueldelval
Valued Contributor

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:

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
Contributor

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)