topic Re: Help with Totalling Data in a table in QlikView

Help with Totalling Data in a table

helen_pip — Thu, 17 Jan 2013 11:03:16 GMT

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?

Re: Help with Totalling Data in a table

Nicole-Smith — Mon, 21 Jan 2013 16:02:27 GMT

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.

Re: Help with Totalling Data in a table

helen_pip — Tue, 22 Jan 2013 12:18:45 GMT

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

Re: Help with Totalling Data in a table

Nicole-Smith — Tue, 22 Jan 2013 13:29:40 GMT

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

Re: Help with Totalling Data in a table

helen_pip — Tue, 22 Jan 2013 13:33:26 GMT

Hello Nicole

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

Thanks

Helen