Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
Hello,
If my understanding is correct, then you are trying to sum all the values of the field IsOpen, where the Teams field equals to 'Help Desk Support' and the YearBL field equals to 2022, which is the current year.
If you are getting unexpected results with your expressions, one recommendation is to always test the expressions in a new app with a new simple dataset. Preferably less records, where you can see clearly what exactly is your expected output and as soon as you make the expression work there, you can transfer it to your original application.
On my side, I have followed the steps below:
1. I have used a simple dataset with few values:
2. The green values are the one that interests us and based on the requirements that you have provided, we need to sum the values 30 and 40, since those are the only values where Teams = Help Desk Support and at the same time YearBl = 2022. Therefore, the expected output is 30+40=70.
3. Now I have loaded the data in Qlik Sense:
4. And I have created an KPI chart with expression: =Sum( {<Teams={'Help Desk Support'}, YearBL={'$(vCurrentYear)'}>} IsOpen )
As you can see, the KPI is 70, which means that the expression is working as expected.
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members.
Hello,
If my understanding is correct, then you are trying to sum all the values of the field IsOpen, where the Teams field equals to 'Help Desk Support' and the YearBL field equals to 2022, which is the current year.
If you are getting unexpected results with your expressions, one recommendation is to always test the expressions in a new app with a new simple dataset. Preferably less records, where you can see clearly what exactly is your expected output and as soon as you make the expression work there, you can transfer it to your original application.
On my side, I have followed the steps below:
1. I have used a simple dataset with few values:
2. The green values are the one that interests us and based on the requirements that you have provided, we need to sum the values 30 and 40, since those are the only values where Teams = Help Desk Support and at the same time YearBl = 2022. Therefore, the expected output is 30+40=70.
3. Now I have loaded the data in Qlik Sense:
4. And I have created an KPI chart with expression: =Sum( {<Teams={'Help Desk Support'}, YearBL={'$(vCurrentYear)'}>} IsOpen )
As you can see, the KPI is 70, which means that the expression is working as expected.
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members.
