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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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