topic Re: Chart expressions, more than 1 condition in QlikView

Chart expressions, more than 1 condition

Tue, 02 Dec 2014 15:07:00 GMT

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

Gysbert_Wassenaar — Tue, 02 Dec 2014 15:11:46 GMT

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

its_anandrjs — Tue, 02 Dec 2014 15:14:04 GMT

By using this condition you can use gender condition also

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

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

Regards

Anand

Tue, 02 Dec 2014 15:55:30 GMT

Thanks but this gives the same % as the overall.

Racine62