Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Gauge filter - Basic Help for Newbie

Hi Guys, I am very new to QlikSense and am trying o evaluate it for business needs, I have a set of gauges that show various values, one of which is counting no. of tickets logged,. i wish to have another gauge that shows number of tickets logged that are are a priority 1.

So my question is how do i filter a gauge to only count tickets where priority Id = 1 ?

my source data would look like the below:

I realise this is very basic but just need a helping hand getting started

Many Thanks

Screen Shot 2015-07-29 at 10.24.31.png

1 Solution

Accepted Solutions
brian_booden
Partner Ambassador
Partner Ambassador

Hi Paul,

Try this:

Count({$<[Priority Id]={1}>}[Task Number])

Regards,

Brian

View solution in original post

3 Replies
brian_booden
Partner Ambassador
Partner Ambassador

Hi Paul,

Try this:

Count({$<[Priority Id]={1}>}[Task Number])

Regards,

Brian

Michael_Tarallo
Employee
Employee

Hello Paul,

Welcome to the Qlik Sense forums and to using Qlik Sense.

Brian is suggesting you use what is called a Set Analysis expression, in which he provided an example. Set Analysis allows you to lock a measure to a specific set of data such as PrioID=1, etc.

You can learn more about Set Analysis an other topics here:

New to Qlik Sense Videos

Here are two you may be interested in:

A Beginners' Introduction to Set Analysis (video)

Set Analysis - Part 2 - Cool Stuff You Can Do (video)

Please let us know how else we can help.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
Michael_Tarallo
Employee
Employee

Hi Paul,

See attached sample using: sum({$<StatusID={'4'}>}Sales)

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik