Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kmstephenson
Creator
Creator

straight table with % with y/n indicator as columns

Hi All,

I create multiple straight tables with % with yes/no indicator set to yes as column expressions.

For example:

COUNT(DISTINCT {<FlagA={'Yes'}>} Key)/COUNT(DISTINCT Key)


This works unless I have selected FlagA='No' in the dashboard. If I have FlagA='No' selected, my table still shows % of patients with FlagA. So instead, I used code:

IF(GetFieldSelections(FlagA)='No',0,COUNT(DISTINCT {<FlagA={'Yes'}>} Key)/COUNT(DISTINCT Key))

Is this the most efficient code I should be using or is there another option within set analysis?

Thanks!

Tina

1 Solution

Accepted Solutions
sunny_talwar

Try this:

COUNT(DISTINCT {<FlagA *= {'Yes'}>} Key)/COUNT(DISTINCT Key)

Implicit Set Operators

View solution in original post

1 Reply
sunny_talwar

Try this:

COUNT(DISTINCT {<FlagA *= {'Yes'}>} Key)/COUNT(DISTINCT Key)

Implicit Set Operators

View solution in original post