Set Analysis Division

Wed, 30 Jan 2013 16:21:06 GMT

I am realtively new to qlikview

I am having a problem using set analysis

I have 2 charts

(Sum ( {<REPORT_LEVEL = {"Detail"}> * <ACCT_TYPE_NAME = {"Liabilities"}> * <ASOFDATE = {'$(=Date(vASOFDATE2))'}> } [MKTVAL]-[BMKTVAL] )

- Sum ( {<REPORT_LEVEL = {"Detail"}> * <ACCT_TYPE_NAME = {"Liabilities"}> * <ASOFDATE = {'$(=Date(vASOFDATE1))'}> } [MKTVAL]- [BMKTVAL] ))

((Sum ( {<REPORT_LEVEL = {"Detail"}> * <ACCT_TYPE_NAME = {"Assets"}> * <ASOFDATE = {'$(=Date(vASOFDATE2))'}> } [MKTVAL]-[BMKTVAL] )

- Sum ( {<REPORT_LEVEL = {"Detail"}> * <ACCT_TYPE_NAME = {"Liabilities"}> * <ASOFDATE = {'$(=Date(vASOFDATE2))'}> } [MKTVAL]- [BMKTVAL] )

+ Sum ( {<REPORT_LEVEL = {"Detail"}> * <ACCT_TYPE_NAME = {"Off Balance Sheet"}> * <ASOFDATE = {'$(=Date(vASOFDATE2))'}> } [MKTVAL]- [BMKTVAL] ))

(Sum ( {<REPORT_LEVEL = {"Detail"}> * <ACCT_TYPE_NAME = {"Assets"}> * <ASOFDATE = {'$(=Date(vASOFDATE1))'}> } [MKTVAL]-[BMKTVAL] )

- Sum ( {<REPORT_LEVEL = {"Detail"}> * <ACCT_TYPE_NAME = {"Liabilities"}> * <ASOFDATE = {'$(=Date(vASOFDATE1))'}> } [MKTVAL]- [BMKTVAL] )

+ Sum ( {<REPORT_LEVEL = {"Detail"}> * <ACCT_TYPE_NAME = {"Off Balance Sheet"}> * <ASOFDATE = {'$(=Date(vASOFDATE1))'}> } [MKTVAL]- [BMKTVAL] )))

I want to have a third chart which is Chart1 / Chart 2 but I get 100% in all dimensions

if I put an expression which is chart 1 expression / chart 2 expression

is the chart 1 set overirding the chart 2 set?

Thanks

topic Set Analysis Division in QlikView