I am realtively new to qlikview
I am having a problem using set analysis
I have 2 charts
1.
(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] ))
2.
((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
