Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
kaylaramsey2
Partner - Contributor III
Partner - Contributor III

IF(GetSelectedCount) Not working

I'm building a chart with a group dimension (Entity -> Dept - >Provider)

My expression is a little complicated.

Sum(AGGR(Count{<ActiveFLG = {'1'}>}Patients)/Count({<ActiveFLG ={'0', '1'}>}Patients)), Level1, Level2, YearNBR, MonthabbreviatedNM))/(Sum(AGGR(Count({<ActvieFLG = {'1'}>} Distinct Level2Response), Level1, Level2, YearNBR, MonthabbreviatedNM)))

 

Now since I have different levels in my chart because of the group dimension I need to rework my expression to include the Entity, Dept, and Provider in the AGGR depending on the level I go to.

So I created an IF statement:

IF(GetSelectedCount(Level1)>=1,Sum(AGGR(Count{<ActiveFLG = {'1'}>}Patients)/Count({<ActiveFLG ={'0', '1'}>}Patients)), Level1, Level2, YearNBR, MonthabbreviatedNM))/(Sum(AGGR(Count({<ActvieFLG = {'1'}>} Distinct Level2Response), Level1, Level2, YearNBR, MonthabbreviatedNM)))

,IF(GetSelectedCount(Entity)>=1,Sum(AGGR(Count{<ActiveFLG = {'1'}>}Patients)/Count({<ActiveFLG ={'0', '1'}>}Patients)), Level1, Level2, Entity, YearNBR, MonthabbreviatedNM))/(Sum(AGGR(Count({<ActvieFLG = {'1'}>} Distinct Level2Response), Level1, Level2, Entity,  YearNBR, MonthabbreviatedNM)))

,IF(GetSelectedCount(Dept)>=1,Sum(AGGR(Count{<ActiveFLG = {'1'}>}Patients)/Count({<ActiveFLG ={'0', '1'}>}Patients)), Level1, Level2, Entity, Dept, YearNBR, MonthabbreviatedNM))/(Sum(AGGR(Count({<ActvieFLG = {'1'}>} Distinct Level2Response), Level1, Level2, Entity, Dept, YearNBR, MonthabbreviatedNM)))

,IF(GetSelectedCount(Provider)>=1,Sum(AGGR(Count{<ActiveFLG = {'1'}>}Patients)/Count({<ActiveFLG ={'0', '1'}>}Patients)), Level1, Level2, Entity, Dept,Provider, YearNBR, MonthabbreviatedNM))/(Sum(AGGR(Count({<ActvieFLG = {'1'}>} Distinct Level2Response), Level1, Level2, Entity, Dept,Provider, YearNBR, MonthabbreviatedNM))))))

 

However, this expression is not working at all.  Basically if a provider is selected then I need it to follow that logic provided above and so on.  Now the logic works if I only have one IF statement but doesnt supply me with the correct answer when I add a second IF statement.  So I think I'm doing something incorrectly with my IF statement.

Labels (2)
0 Replies