topic Re: help with expression in QlikView

help with expression

arusanah — Tue, 23 Aug 2016 16:52:08 GMT

My requirement is if GetSelectedCount(Enrollment filter) is 0 ,I should see default count values .I selected Enrollment Filter="New Enrollments", so my Disenrolled Field should show 0 , but instead its showing me Default count. I am using Following expression . but this is not working .

Please help!

Disenrolled calc:

if(GetSelectedCount(MonthYear)=0,
if(GetSelectedCount([Enrollment Filter])=0,Count( {<[Disenrolled Indicator]={'Y'} ,[Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"}>} [Recipient Identifier]),

      if([Enrollment Filter]='Enrollment',
       Count( {<[Disenrolled Indicator]={'Y'} ,[Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"}>} [Recipient Identifier]),

               if([Enrollment Filter]='New Enrollments',
                0 ,

         if([Enrollment Filter]='Disenrollments',
     Count( {<[Disenrolled Indicator]={'Y'} ,[Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"}>} [Recipient Identifier])

           )
         )
       )
)
)

Re: help with expression

othniel2014 — Tue, 23 Aug 2016 17:42:32 GMT

Change this

Count({<

[Disenrolled Indicator]={'Y'} ,

[Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"}>}

[Recipient Identifier])

For this

Count({1<

[Disenrolled Indicator]={'Y'} ,

[Date]={$(='">= '& $(=varMinSelectedDate) & ' <= ' & $(=varSelectedDate) &'"')}

//or this

// [Date]={$(='">= '& $(varMinSelectedDate) & ' <= ' & $(varSelectedDate) &'"')}

>} Sales)

Or this

Count({<

[Disenrolled Indicator]={'Y'} ,

[Date]={$(='">= '& $(=varMinSelectedDate) & ' <= ' & $(=varSelectedDate) &'"')}

//or this

// [Date]={$(='">= '& $(varMinSelectedDate) & ' <= ' & $(varSelectedDate) &'"')}

>} Sales)

I use "Count({1<" for this ">= ## <= ##"

Edit:

if(GetSelectedCount(MonthYear)=0,

if(GetSelectedCount([Enrollment Filter])=0,

Count({1<[Disenrolled Indicator]={'Y'} ,[Date]={$(='">= '& $(varMinSelectedDate) & ' <= ' & $(varSelectedDate) &'"')}>}[Recipient Identifier]),

if([Enrollment Filter]='Enrollment',

Count({1<[Disenrolled Indicator]={'Y'} ,[Date]={$(='">= '& $(varMinSelectedDate) & ' <= ' & $(varSelectedDate) &'"')}>}[Recipient Identifier]),

if([Enrollment Filter]='New Enrollments',

0 ,

if([Enrollment Filter]='Disenrollments',

Count({1<[Disenrolled Indicator]={'Y'} ,[Date]={$(='">= '& $(varMinSelectedDate) & ' <= ' & $(varSelectedDate) &'"')}>}[Recipient Identifier])

)

Re: help with expression

Anonymous — Tue, 23 Aug 2016 17:50:48 GMT

Why dont you use,

if(GetSelectedCount(MonthYear)=0,

if([Enrollment Filter]='New Enrollments', 0 ,

Count( {<[Disenrolled Indicator]={'Y'} ,[Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"}>} [Recipient Identifier])

))