Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Currently I’m having issues with the Climber KPI, please see below the object Version:
This is the QS version we are using at this point:
I'm cooking some expressions to have a Climber KPI showing the count of cases for the Current year, when no year has been selected. The same Climber KPI will Show the Count of the year selected by the user, once the user pick one from the filters.
My problem is that the Climber KPI Trend is not being showed correctly for the option when no year is selected.
Let’s me start with the case in which is working:
I obtain this whit the simple expressions:
I also Obtain this behavior when 2019 is selected on the filters and I’m using this Expressions:
The problem is when I want to show current versus previous year for the situation in which no selection using the expressions above:
The logic of the expression is the following:
What I’m looking for is that my default state, no year selected looks like the first picture.
I have already tried simplified expressions without getfieldselections or variables. The problem only occurs when evaluating from the IF. In that cases the image of the trends are all compressed to the left.
Can you give me any help on this one?
Hi Leo,
It looks like your formula is only evaluating for 2019, it that correct? What if you put the same calculation in a table? What does the table show you? Make sure you have the same dimensions in your table.
Jordy
Climber