Help with Totalling Data in a table

[helen_pip]

Hello

I was wondering if someone could help me

I have attached a QVW which shows information for 2 categories MAIN and EYE

I need help writing the information for a 3rd table which adds both MAIN and EYE data together to make a table called TOTAL

I am unsure how to do this as I have drill down groups in each existing table, both of which the sources are coming from different data sources

Can anyone help me on the way to achieving this?

[Nicole-Smith]

You really should be storing all of your data in the same table and then using set analysis to just get Main and Eye when you want them separately.  This should be done something like this:

Table:

LOAD ID,

     If([ADM]=1, 'ADMITTED', 'NON_ADMITTED') as ADM,

     Total,

     Interim,

     Mode,

     Com,

     Diag,

     'Main' as Source

FROM

Q:\DEVELOPMENT\HP\Qlikview_Community_Example\17012013\Main.xls

(biff, embedded labels, table is Sheet1$);

CONCATENATE (Table)

LOAD ID as ID,

     If(ADM='Y', 'ADMITTED', 'NON_ADMITTED') as ADM,

     Total,

     Interim,

     Mode,

     Com,

     Diag,

     'Eye' as Source

FROM

Q:\DEVELOPMENT\HP\Qlikview_Community_Example\17012013\Eye.xls

(biff, embedded labels, table is Sheet1$);

If you need further help with the set analysis for the charts, please post sample .xls files so that I can actually reload the document with the script that I have above.

[helen_pip]

Hello Nicole

Thank you for your help and I ahve found it very useful

Could you kindly help me with the set analysis for the 3rd table which totals both Main and Eye together as this is the bit that I will struggle with most

I have attached the excel files to the original post

Any help would be greatly appreciated

Thanks

Helen

[Nicole-Smith · Accepted solution]

Solution is attached.  I made changes to the load script and all 3 tables.  This should be right what you need.

[helen_pip]

Hello Nicole

Thank you so much for your help, you really have helped and I appreciate it

Thanks

Helen