topic Eliminate values in QlikView

Eliminate values

sfloberg — Fri, 26 May 2017 08:17:56 GMT

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?

migueldelval — Fri, 26 May 2017 08:51:55 GMT

Hi Stephanie,

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

Regards

Miguel del Valle

sfloberg — Fri, 26 May 2017 09:09:06 GMT

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 — Fri, 26 May 2017 09:27:47 GMT

Hi Stephanie,

Could you attach an data example?

I don´t understand you so well,

Regards

Miguel del Valle

sfloberg — Fri, 26 May 2017 09:33:12 GMT

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

Anonymous — Fri, 26 May 2017 09:50:52 GMT

Can you use calculated dimension something like

if (getpossiblecount(year>0,Project)