KPI If Statement Object Text - Variable or If Statement as List Box Value,

[educastri83]

Hi everybody!!

I need to resolve several things with my Risk Management Board.

You see, in my model I have 5 risks and I do semiannual comparisons do this by Set Analysis. In the example, there is data 2015-H2 and 2016-H1. The risks are qualified with scores ranging from 1 to 25 where among higher increased risk.

Let's do it !!!

1. First I want to create text objects that serve as KPI's with the count for each risk trend. There are 3 types of trends or variations from one period to another:
* Risks that increase
* Risk decreasing
* Risk unchanged

2. I would like to include list boxes to select 3 risk trends, and regardless of whether the KPI's at the top of my Dashboard indicating the amount by trend. I want to create a list box.

3. In my trend simple table summarizes the risks and also shows an expression using the IF statement to know the trend risk.
I have problems with Variable = vRiskVariation not bring me the trend that actually has the risk.

Thank you very much!!!

P.D: Attachment qvw file

[sunny_talwar · Accepted solution]

Can you check if these are the things you were looking to get?

[educastri83]

Thanks!!!!!!

Sunny! yeah that it's!! You've resolve my problem.

Thanks a lot!!