Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Partner
Partner

Eliminate values

I have a KPI object but it gives me too many projects. I noticed that there are several projects without any year connected

to it when I put the expression in a straight table. I want to eliminate the project that don't have a year.

How can I write an expression like Count(distinct Projectnumber) and eliminate those without year in a KPI object?

Tags (1)
5 Replies
migueldelval
Valued Contributor

Re: Eliminate values

Hi Stephanie,

Maybe you can check-out "Zero Values" or use Count(Distintc {<Ar={"*"}>}Projeknummer)

Regards

Miguel del Valle

Partner
Partner

Re: Eliminate values

I can't check out null values because I have values.

I tried your expression but it didn't give me the correct answer.

migueldelval
Valued Contributor

Re: Eliminate values

Hi Stephanie,

Could you attach an data example?

I don´t understand you so well,

Regards

Miguel del Valle

Partner
Partner

Re: Eliminate values

I get 2 435 in the KPI object when using your expression. I should be getting 4 117.

Year2.png

qvhelpplease
New Contributor III

Re: Eliminate values

Can you use calculated dimension something like

if (getpossiblecount(year>0,Project)