topic Count Null Value in a set analysis in QlikView

Count Null Value in a set analysis

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

Hello everyone,

I'm new to Qlikview and i would like to display a bar chart with thoses datas

Basically i would like to display thoses lines by priority (Assigned, Pending and Work in progress) based on the facts that there are no resolved yet.

I tried those 3 formulas :

= Count({$<Priority = {'Priority 3 - Medium'},Status = {'Assigned'}, Status = {'Pending'},Status = {'Work in Progress'}>} Priority)

= Count({$<Priority = {'Priority 1 - Critical'},Status = {'Assigned'}, Status = {'Pending'},Status = {'Work in Progress'}>} Priority)

= Count({$<Priority = {'Priority 2 - High'},Status = {'Assigned'}, Status = {'Pending'},Status = {'Work in Progress'}>} Priority)

Count({$<Priority = {'Priority 4 - Low'},Status = {'Assigned'}, Status = {'Pending'},Status = {'Work in Progress'}>} Priority)

But WHen i tried i get only one value while there are many values to display

I Tried this type of formula : Count({<Resolved = {''}, Priority={''Priority 3 - Medium}>} Priority) But it doesn't seem to work. QV doesn't seem to read field with empty value.

If someone could help it will be great

Re: Count Null Value in a set analysis

Miguel_Angel_Baeyens — Wed, 23 May 2018 14:12:47 GMT

Are they real nulls? If so, you cannot count them but there are workarounds.

You can also use something like this in the set analysis:

Count({< Resolved = {"=Len(Resolved) = 0"} >} Priority)

However, it's not nice. You can flag in the script which lines are empty and count or sum that flag instead.

Re: Count Null Value in a set analysis

YoussefBelloum — Wed, 23 May 2018 14:13:55 GMT

Hi,

with the data on the image you have attached above, what is your expected output ?

Re: Count Null Value in a set analysis

qlikviewwizard — Wed, 23 May 2018 14:17:33 GMT

Can you attach some dummy data to demonstrate the issue?

Re: Count Null Value in a set analysis

lessassy — Wed, 23 May 2018 14:30:11 GMT

Basically

My datas are those

INC/RITM is Incidents tickets.

Basically I want Qlikview to display incidents that are still not resolved by priority.

To do that i have to select the status Pending, Assigned and Work in Progress which are an indication that there are not closed.

I wanted to use the colomun Resolved as if it's empty it's mean that the incident is not solved. But I figured out that there are issues on my data. So the only reliable field are Status and priority. THe field where i tried those formulas:

= Count({$<Priority = {'Priority 3 - Medium'},Status = {'Assigned'}, Status = {'Pending'},Status = {'Work in Progress'}>} Priority)

= Count({$<Priority = {'Priority 1 - Critical'},Status = {'Assigned'}, Status = {'Pending'},Status = {'Work in Progress'}>} Priority)

= Count({$<Priority = {'Priority 2 - High'},Status = {'Assigned'}, Status = {'Pending'},Status = {'Work in Progress'}>} Priority)

Count({$<Priority = {'Priority 4 - Low'},Status = {'Assigned'}, Status = {'Pending'},Status = {'Work in Progress'}>} Priority)

And it didn't work anyway.

Any solutions.

Thank for the help i really appreciate