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

educastri83 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

sunny_talwar — Mon, 24 Oct 2016 06:16:47 GMT

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

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

educastri83 — Mon, 24 Oct 2016 10:35:52 GMT

Thanks!!!!!!

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

Thanks a lot!!

topic Re: KPI If Statement Object Text - Variable or If Statement as List Box Value, in QlikView

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

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

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