Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight table count values

Hi

I have a straight table in which i am calculating a count

My requirement is, if i have a value 1 in count it should show as 'Y'

My requirement is, if i have a value 0 in count it should show as 'N'


   

employeestatuscount({<status=={'hold'>}>employee)my expexted out put
aaaahold1       y
bbbun hold0       n
ccchold1        y
dddunhold0        n

Thank you



1 Solution

Accepted Solutions
sunny_talwar

May be this:

Pick(Count({<status={'hold'>}>employee) + 1, 'n', 'y')

View solution in original post

2 Replies
sunny_talwar

May be this:

Pick(Count({<status={'hold'>}>employee) + 1, 'n', 'y')

Not applicable
Author

Thank you so much Sunny