Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ArmyDrillSGT
Contributor
Contributor

Need help with my KPI Chart providing value based on two conditions

I am new to Qlik need help with my KPI Chart providing value based on two conditions. Please help asap!

ArmyDrillSGT_0-1673636401476.png

I would like my KPI Chart to show the total #vehicles by RO_NAME, and SA_PERIOD

ArmyDrillSGT_0-1673636882209.png

 

 

 

Labels (3)
4 Replies
KGalloway
Creator II
Creator II

A KPI chart will only show a single summary statistic, so it may not be the most appropriate chart for your needs.

You may want to try using a table, pivot table, or bar chart with RO_NAME and SA_PERIOD as the dimensions and sum([# VEHICLES]) as the measure.

ArmyDrillSGT
Contributor
Contributor
Author

Thanks KGalloway. However, I only need a set expression script to total dates that are the same to sum the number of vehicles.

Example -

Fort Hunter Liggett Resident, Date 202209, #Vehicles (7)

MOTCO, Date 202209, #Vehicles (5)

Sacromento Resident Office, Date 202209, #Vehicles (12)

Total = 24

Is there a script/set expression to pull that result in my KPI Chart?

 

KGalloway
Creator II
Creator II

So you want to see the totals for a given SA_Period for all RO_NAME locations? If I'm understanding that correctly, the following might work:

sum({<SA_PERIOD = {'202209'}>} [# VEHICLES])

This should sum the number of vehicles for SA_PERIOD = 202209 for all RO_NAME locations.

ArmyDrillSGT
Contributor
Contributor
Author

Thank you KGalloway! Your solution works!