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: 
Anonymous
Not applicable

Friends Can anyone help to consildate script

Hi Friends,I am stuck with work can u plz do needful.Having 3 Excel files in almost all columns all dimensions are common some are differ i concatenated generated qvd.In separate sheet i need Conditions to measure all

Model:
LOAD [Order No] ,
     [Pick Slip No],
     [Manager Code],
     [CustId],
Source,
Minor,
Class,
       Local,
Number,
     Model Group,
     Status,
ModelNo,
  Amount as [Retail Amount]

  

where Match(Status,'PG','PC');

[Retail Model]:
NoConcatenate
Load [Order No] ,
     [Pick Slip No],
     [Manager Code],
     [CustId],
Source,
Minor,
Class,sum([Retail Amount]) as [Amount]
         Resident [Model]
        Group by [Order No],[Pick Slip No],[Manager Code],[CustId],Source,Minor,Class

I need to get all data at script level.First loading one data source used where Match(Status,'MA','TH'); and used group by with dimension for all measures separately in script and generated qvd separetly,synthatic keys are forming i.e,Need all script in temp like table where calculations are to be done not changing sources.In detail i have another source where almost all dimensions  are same ther is no primary key but at final both are to be compared side by side.

the dimensions in Model,sales,Loss.xlx all are checked in pivot table.

The Dimensions are common in all excels

                :Order No

                  Pick Slip No

                  CustId

                  Source

                   Minor

                   Class

Model.xlx Measures:Income

                              Sales

Sales.xlx  Measure: Puchase

                              Ledger

Loss.xlx  Measure: Net Loss

                              Gross lossCapture123.PNG

Amount Values act like a hyperlink on clicking it chould populate pivot table with default dimension and matching should show Amount at lowest drill downs.

2)To show Welcome tab first scrren with current user login Name

All measure are to be displayed

3 Replies
tresesco
MVP
MVP

Learn about Drill Down Group. Or, you can take two objects (using conditional appearance).

Drill Down

Anonymous
Not applicable
Author

In script to get different measures i need a solution to get all script together not like above script which have written for individual calculations.Measure with corresponding Amounts


Anonymous
Not applicable
Author

can Any one help me in scripting?started discussion