Selection on Set Analysis Values

shumailh — Sun, 22 Nov 2009 14:55:51 GMT

I want to see the trend on set analysis value but i couldn't figure out how to make selection on it. Below are the two expression on which i applied set analysis.


1. Revolver = Count({$<AIF = {P} , TXN_MainType = {Interest} , LoadDay_Active = {$(#=ReportDay)}>} AIF)
2. Transactor = Count({$<AIF = {P}, LoadDay_Active = {$(#=ReportDay)}>} (AIF)) - Count({$<AIF = {P}, TXN_MainType = {Interest}, LoadDay_Active = {$(#=ReportDay)}>} (AIF))

Can we make selection on expression "2. Transactor"?

Selection on Set Analysis Values

shumailh — Tue, 24 Nov 2009 22:21:03 GMT

OR

Can anyone help me to write the opposite of the below code

<pre>
1. Revolver = Count({$<AIF = {P} , TXN_MainType = {Interest} , LoadDay_Active = {$(#=ReportDay)}>} AIF)

Total = Revolver (80) + Transactor (20)
Total = 100 = 80:20

I have two variables Revolver and Transactor as mention in the code. both of them are inversely proportional to each other.

I got the correct value for revolver but i couldn't get the inverse of it for transactor. I tried below code but it's not working.

2. Transactor= Count({$<AIF = {P} , ~TXN_MainType = {Interest} , LoadDay_Active = {$(#=ReportDay)}>} AIF)

Below is the code which works for Transactor but i cant make selection on it...


2. Transactor = Count({$<AIF = {P}, LoadDay_Active = {$(#=ReportDay)}>} (AIF)) - Count({$<AIF = {P}, TXN_MainType = {Interest}, LoadDay_Active = {$(#=ReportDay)}>} (AIF))

Can anyone help me on this

topic Selection on Set Analysis Values in QlikView

Selection on Set Analysis Values

Selection on Set Analysis Values

OR

2. Transactor= Count({$<AIF = {P} , ~TXN_MainType = {Interest} , LoadDay_Active = {$(#=ReportDay)}>} AIF)