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

Announcements
Join us in NYC Sept 4th 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