Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (1)
1 Solution

Accepted Solutions
brian_booden
Contributor

Re: Gauge filter - Basic Help for Newbie

Hi Paul,

Try this:

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

Regards,

Brian

3 Replies
brian_booden
Contributor

Re: Gauge filter - Basic Help for Newbie

Hi Paul,

Try this:

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

Regards,

Brian

Employee
Employee

Re: Gauge filter - Basic Help for Newbie

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

Employee
Employee

Re: Gauge filter - Basic Help for Newbie

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