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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
MIKIEMILLER
Contributor III
Contributor III

Identifier in a count formula

So I don't know what I am doing wrong.  I dont want any selections to change this number.  but placing a 1 inside the set analysis is not doing anything.

This is what I currently have now:

Count({1<[Challenge Appeal?]={'Y'}>}[Challenge Appeal?])
/
(Count({1<[Challenge Appeal?]={'Y'}>}[Challenge Appeal?])+Count({<[Challenge Appeal?]={'N'}>}[Challenge Appeal?]))

Can anyone explain what I am doing wrong?

1 Solution

Accepted Solutions
MIKIEMILLER
Contributor III
Contributor III
Author

That's it.  Thanks

View solution in original post

2 Replies
sunny_talwar

May be one of the 1s are missing

Count({1<[Challenge Appeal?]={'Y'}>}[Challenge Appeal?])
/
(Count({1<[Challenge Appeal?]={'Y'}>}[Challenge Appeal?])+Count({1<[Challenge Appeal?]={'N'}>}[Challenge Appeal?]))
MIKIEMILLER
Contributor III
Contributor III
Author

That's it.  Thanks