Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have list of engineer's who have undertaken an audit, as shown below in my example.
Using Qlik Sense, I wish to have a table showing those engineers who have a score above zero for the the current month. I don't wish to use a filter pane or restrict my load data.
Can somebody help, as I've spent age s looking for a solution.
Engineer | Date | Score |
Mike | 03-Jan-22 | 5 |
Joe | 03-Jan-22 | 10 |
Gill | 03-Apr-22 | 25 |
….. | ||
Brandon | 08-Nov-22 | 15 |
Fred | 09-Nov-22 | 0 |
Hi, you can add a table with Engineer as dimension as this expression: Sum({<Engineer={"=MonthName(Date)=MonthName(Today())"}>} Score)
This will show the engineers with Score on this month (in the sample you posted, just Brandon, with an score of 15).
You might not need a sum of score, this is just an example on the set analysis that filters engineers with score in this month.
Hi, you can add a table with Engineer as dimension as this expression: Sum({<Engineer={"=MonthName(Date)=MonthName(Today())"}>} Score)
This will show the engineers with Score on this month (in the sample you posted, just Brandon, with an score of 15).
You might not need a sum of score, this is just an example on the set analysis that filters engineers with score in this month.
You can use the example as stated by Ruben below if you are trying to sum the score, if not use if and else condition. for example;
if (Score >0, Score, null()) in the measure, or if you want to filter out on the dimensions itself use if (score>0, Engineer, Null()), you can do it either way, as per your requirement.