Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
smusayev
Not applicable

Set Measure to a specific Field.

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

1 Solution

Accepted Solutions
jason_michaelid
Not applicable

Re: Set Measure to a specific Field.

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

1 Reply
jason_michaelid
Not applicable

Re: Set Measure to a specific Field.

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