Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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