Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
matthewp
Creator III
Creator III

Text box expression to ignore selections

I have a text box with an expression in and i would like it to ignore my selections.

='% Total:' & round(Count(DISTINCT{1} If((Date(MonthName(CREATION_DATE),'MMM-YY')) >= (AddMonths(Today(),-12)),S_ID))

/(100)&'%'

1 Reply
sunny_talwar

May be this:

='% Total:' & round(Count(DISTINCT{1} If((Date(MonthName(Only({1}CREATION_DATE)),'MMM-YY')) >= (AddMonths(Today(),-12)),S_ID))

/(count({1}DISTINCT{$<[STATUS]={'Active'} > } [S_ID]) + count({1}DISTINCT{$<[STATUS]={'Inactive'} > } [S_ID]) )*100)&'%'