Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
aschmeelk
Contributor III
Contributor III

Keeping a KPI from changing with filter selections.

 

I have a KPI on a sheet that I want to have and keep the value for a specific set modifier no matter what is selected on the sheet.  Example:

turntime.PNG 

So here, the large value will be the Site, the small value should be the average of All sites (There are 4 KPIs one for each site.)

 
This KPI has the following Measures:

Average(for specific site): 

Avg(Aggr({<PLANT_CODE={'BET'}>} //Site location code
Floor(Only(
{<[Process Code]-={'CC','CP','BS'},[Tread]-={'POOL','REPONLY'},[Casing Status]-={'DELETED'}>}[Completed Date]))
-
Floor(Only(
{<[Casing Status]-={'DELETED'}, [gra_audit_trail.POST_NAME]={'RECEIVING'},ACTION_NAME={'SHIP_RECEIVING'}>}[Audit Create]))
,[Tag #]))

This Seems to work, except that when I select a filter item ie Year, Customer, Plant Name from the filter bar(below),

auditfilterbar.PNG

the KPI values change.
I want it to always reflect the average for the site code selected and I can't seem to make this happen!

Any help or insights are appreciated!

Labels (1)
1 Solution

Accepted Solutions
Lauri
Specialist
Specialist

Did you put 1 in all 4 places, including for the Avg function?

Avg({1} Aggr({1<PLANT_CODE={'BET'}>} //Site location code
Floor(Only(
{1<[Process Code]-={'CC','CP','BS'},[Tread]-={'POOL','REPONLY'},[Casing Status]-={'DELETED'}>}[Completed Date]))
-
Floor(Only(
{1<[Casing Status]-={'DELETED'}, [gra_audit_trail.POST_NAME]={'RECEIVING'},ACTION_NAME={'SHIP_RECEIVING'}>}[Audit Create]))
,[Tag #]))

View solution in original post

4 Replies
jwjackso
Specialist III
Specialist III

Try using {1} as part of you set analysis statement.

aschmeelk
Contributor III
Contributor III
Author

Yeah, I've tried that, doesn't seem to work.

Lauri
Specialist
Specialist

Did you put 1 in all 4 places, including for the Avg function?

Avg({1} Aggr({1<PLANT_CODE={'BET'}>} //Site location code
Floor(Only(
{1<[Process Code]-={'CC','CP','BS'},[Tread]-={'POOL','REPONLY'},[Casing Status]-={'DELETED'}>}[Completed Date]))
-
Floor(Only(
{1<[Casing Status]-={'DELETED'}, [gra_audit_trail.POST_NAME]={'RECEIVING'},ACTION_NAME={'SHIP_RECEIVING'}>}[Audit Create]))
,[Tag #]))

aschmeelk
Contributor III
Contributor III
Author

Thank you! Adding the {1}  to the AVG function did the trick.