Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Paul,
Try this:
Count({$<[Priority Id]={1}>}[Task Number])
Regards,
Brian
Hi Paul,
Try this:
Count({$<[Priority Id]={1}>}[Task Number])
Regards,
Brian
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:
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
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