topic Re: QlikView in QlikView

QlikView

Balujyothi4 — Sat, 16 Apr 2022 17:32:11 GMT

I have a column name "active" and fields are "True" and "False". Now I want create a KPI as "No of Active projects".

There are 75 - True and False - 25.

So I need out put in KPI as 75.

Please can any help me out how can we write expression.

Re: QlikView

Vegar — Sat, 16 Apr 2022 18:19:47 GMT

@Balujyothi4 wrote:

Hi

I have a column name "active" and fields are "True" and "False". Now I want create a KPI as "No of Active projects".

There are 75 - True and False - 25.

So I need out put in KPI as 75.

Please can any help me out how can we write expression.

Assuming that you can count no of project by the expression Count(ProjectID), make adjustments to my suggestion to fit your data.

Num(Count({<Active={'True'}>}ProjectID)/count(ProjectID),'0%')

Re: QlikView

Balujyothi4 — Sat, 16 Apr 2022 18:23:32 GMT

Think you so much vegar, its worked