topic Re: Only use dimension with value in QlikView

Only use dimension with value

pauldamen — Tue, 03 Jan 2017 13:44:19 GMT

Hi,

I have a graph were I divide the number of hours with the number of people (in printscreen see top line chart)

What you see in my listbox on the left I have 8 people. But only 4 with hours (see bottom table). Now it divides the number of hours with 8 people. What I need is that the number of hours is divided by only people who have hours. How can I achieve this?

Regards, Paul

Re: Only use dimension with value

sunny_talwar — Tue, 03 Jan 2017 13:52:22 GMT

You have not shared your expression, but based on some assumptions, try this:

=Sum({<TypeUrenHoofdcategorie = {'Productief'}>} Uren)/Count(DISTINCT {<Finexter = {"=Sum({<TypeUrenHoofdcategorie = {'Productief'}>} Uren) > 0"}>} Finexter)

Re: Only use dimension with value

pauldamen — Tue, 03 Jan 2017 14:22:35 GMT

Thanks Sunny, works great!