Friends Can anyone help to consildate script

Anonymous — Mon, 15 Sep 2014 10:19:37 GMT

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 loss

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

Re: Friends Can anyone help to consildate script

tresB — Mon, 15 Sep 2014 10:24:26 GMT

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

Drill Down

Re: Friends Can anyone help to consildate script

Anonymous — Mon, 15 Sep 2014 10:38:02 GMT

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

Re: Friends Can anyone help to consildate script

Anonymous — Mon, 15 Sep 2014 11:30:41 GMT

can Any one help me in scripting?started discussion

topic Re: Friends Can anyone help to consildate script in QlikView

Friends Can anyone help to consildate script

Re: Friends Can anyone help to consildate script

Re: Friends Can anyone help to consildate script

Re: Friends Can anyone help to consildate script