This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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-
"Customer Group Descr",
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
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
Miguel del Valle
View solution in original post
what error it is showing?
What is the name of first table, when you load a "PNL QVD"?
its showing PnL not found
The qvd is cease and the table is pnl.
Could you attach your script?
Hi PFA screenshots of the script
instead of *
From PNl .qvd
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.
I have 2 different tables having almost the same colmuns being loaded from two different sources which i merged in a single qvd(cease)