Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
You could concatenate EventId & Category as your dimension and then ignore the EventId in your chart dimension and measures. Attached is an example that demonstrates this. For a more robust example see https://qlikviewcookbook.com/2018/02/qdg-guru-day-inspiration/
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
The example helps. Seems like all you are missing is how to get the set expression into your x-axis expression. Use only() like this:
RangeMin(12/(650/ only({<TASK_COUNT=>}ACCOMP_FC)), 12/(5000 / only({<TASK_COUNT=>}ACCOMP_FH)),only({<TASK_COUNT=>}ACCOMP_MO))
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
You could concatenate EventId & Category as your dimension and then ignore the EventId in your chart dimension and measures. Attached is an example that demonstrates this. For a more robust example see https://qlikviewcookbook.com/2018/02/qdg-guru-day-inspiration/
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
This is coooool!
concatenating the dimension works well. At least it selects the "event category" automatically, this means it is a single click to get what I want .
The measures involved, however, are quite complicated to wrap in the "if" syntax.
here is the example:
measure 1:
RangeMin(12/(((median(COUNT_DISTINCT_of_flight_id)) / ACCOMP_FC)), 12/(((median(SUM_of_Flight_Hours)) / ACCOMP_FH)),ACCOMP_MO) -
I cant quite get the syntax right to add the set analysis...
Measure 2 :
((Sum(Aggr(Sum(TOTAL <TASKNUMBER> TASKMH), EventID, EventCat)) +
Sum(Aggr(Sum(TOTAL <TASKNUMBER> ACCESSMH), EventID, EventCat)) +
Sum(Aggr(Sum(TOTAL <TASKNUMBER> PREPMH), EventID, EventCat)))
* 75 * 2)/24
I would think that you could just add {<EventId=>} into your aggregation functions. But it also could be that your starting premise is more complex than it needs to be. Any chance you could upload a sample QVF? You can put some dummy data in or drop the sensitive fields from the model.
-Rob
There are over 17000 events. They reoccur on a schedule. It looks daunting but using other filters it makes sense. I have removed other identifying details.
The example helps. Seems like all you are missing is how to get the set expression into your x-axis expression. Use only() like this:
RangeMin(12/(650/ only({<TASK_COUNT=>}ACCOMP_FC)), 12/(5000 / only({<TASK_COUNT=>}ACCOMP_FH)),only({<TASK_COUNT=>}ACCOMP_MO))
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com