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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart expressions, more than 1 condition

Hi,

I have a chart expression:

COUNT({<AGREEN={1}>}QData)/COUNT(QData)  which gives a % Agree score.

I want another  chart expression that gives this % for just one particular value of another field (eg Gender).

Is there a way I can do this by adapting the existing chart expression?. 

Regards,

Racine1962

1 Solution

Accepted Solutions
its_anandrjs
Champion III
Champion III

By using this condition you can use gender condition also

COUNT({<AGREEN={1}, Gender={'M'}>}QData)/COUNT(QData)


Or


COUNT({<AGREEN={1}, Gender={'M'}>}QData)/COUNT({<Gender={'M'}>}QData)


Regards

Anand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

COUNT({<AGREEN={1},Gender={'Female'}>}QData)/COUNT(QData


talk is cheap, supply exceeds demand
its_anandrjs
Champion III
Champion III

By using this condition you can use gender condition also

COUNT({<AGREEN={1}, Gender={'M'}>}QData)/COUNT(QData)


Or


COUNT({<AGREEN={1}, Gender={'M'}>}QData)/COUNT({<Gender={'M'}>}QData)


Regards

Anand

Not applicable
Author

Thanks but this gives the same % as the overall.

Racine62