Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
shumailh
Contributor III

Selection on Set Analysis Values

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"?

1 Reply
shumailh
Contributor III

Selection on Set Analysis Values

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... Tongue Tied


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