Set Measure to a specific Field.

[smusayev]

Hello,

I have chart that measures compliance rate per month.

The following are my dimension and measures.

Dimension:  Month

Dimension:  Compliant

Measure (expression):  Count( {<Compliant = {'Yes'} >} Month )/Count(Total <Month> Compliant)

This gives me a beautiful chart that measure compliance rate by month, and if I click a specific department it will present the compliance rate for that location as well.

However I would like to also create another monthly chart but only set to a specific location (for example location 'B2A').

( I have been able to create a gauge meter set to a specific location based on help from a Qlik community members by using the following:

Count({<Compliant={'Yes'},Location={'B2A'}>} Compliant) /Count({<Location={'B2A'}>} Compliant)

I would like to reproduce the same logic as for gauge meter but see the compliance change between months.

Please help or advice.

Thank you

[Jason_Michaelides · Accepted solution]

Can't you just add the second set modifier in?

Measure (expression):  Count( {<Compliant = {'Yes'},Location={'B2A'}>} Month )/Count({<Location={'B2A'}>} Total <Month> Compliant)

Hope this helps,

Jason