Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arusanah
Creator II
Creator II

help with expression

Since we cannot set default value for app , I'm trying to modify expressions for visualizations to set default value but its throwing error.

pls help!!!

count( distinct {$<if(GetSelectedCount(MonthYear)=0,MonthYear={date(max(MonthYear-1),'MMM-YYYY')}),[Enrollment]={'Enrollment'}>}[IDN_RCPT])

4 Replies
sunny_talwar

Try this:

If(GetSelectedCount(MonthYear) = 0, Count(DISTINCT {<MonthYear={"$(=Date(AddMonths(Max(MonthYear), -1),'MMM-YYYY')}, [Enrollment]={'Enrollment'}>} [IDN_RCPT]), Count(DISTINCT {<[Enrollment]={'Enrollment'}>} [IDN_RCPT]))

arusanah
Creator II
Creator II
Author

Hi Sunny,

Above expression doesn't work.

sunny_talwar

Sorry, I missed a double quote, try this:

If(GetSelectedCount(MonthYear) = 0, Count(DISTINCT {<MonthYear={"$(=Date(AddMonths(Max(MonthYear), -1),'MMM-YYYY')"}, [Enrollment]={'Enrollment'}>} [IDN_RCPT]),Count(DISTINCT {<[Enrollment]={'Enrollment'}>} [IDN_RCPT]))

arusanah
Creator II
Creator II
Author

this part of expression is not working

Count(DISTINCT {<MonthYear={"$(=Date(AddMonths(Max(MonthYear), -1),'MMM-YYYY')"}, [Enrollment]={'Enrollment'}>} [Recipient Identifier]))