topic Re: Fields compare in relation to quality control in QlikView

Fields compare in relation to quality control

Wed, 01 Aug 2012 09:32:00 GMT

Hello,

I want to try to improve the quality of input into our system.
There are 4 fields being:
I_PRnr is numeric, P_Systeem is text
I_INnr is numeric, I_Systeem is text.

I_INnr is a unique incident number and I_Systeem an system name, the same for I_PRnr and P_Systeem.
Each PRnr can be linked to multiple I_INnr.

If I_INnr is coupled to a I_PRnr, P_Systeem must be equal to I_Systeem.

Field quality in inputtab should be determind by QV, Nok or Ok.

I've included an example with two tabs Input en output.

I hope someone can help me.

Sincerely

Frans

As a result, a percentage specified by I_PRnr.
I hope that someone understand what I mean.

Re: Fields compare in relation to quality control

Wed, 01 Aug 2012 10:58:07 GMT

A simple chart (straight table) should work.

You divide the count of "OK" by the count of all.

Dimension:

I_PRnr

Expression:

count({$ <Quality={'Ok'}>} distinct I_INnr)
/
count({$ <Quality=>} distinct I_INnr)

Re: Fields compare in relation to quality control

Wed, 01 Aug 2012 11:10:43 GMT

Hello,

Hi, thanks for your response.
The problem is that the Quality table (Ok, Nok) does not exist right now, it must be generated by a script.

After that I can use your Expersion.

count({$ <Quality={'Ok'}>} distinct I_INnr) / count({$ <Quality=>} distinct I_INnr)

Thanks in advance,

Frans

Re: Fields compare in relation to quality control

Wed, 01 Aug 2012 11:17:17 GMT

I don't understand your phrase:

If I_INnr is coupled to a I_PRnr, P_Systeem must be equal to I_Systeem.

What do you mean by "coupled"? Not null?

Then you can add in your load script a field

if(isnull(I_INnr) = false() and isnull(I_PRnr) = false() and P_Systeem <> I_Systeem, 'Nok', 'Ok') AS Quality

Re: Fields compare in relation to quality control

Wed, 01 Aug 2012 11:38:24 GMT

The subject is incident management and problem management (ITIL), a problem may consist of multiple incidents. This link may only take place if P_Systeem = I_Systeem.

P_Systeem and I_Systeem are functional names in our database ITSM.

Coupled with, I mean there is a 1 to n relationship between a problem and 1 or more incidents involving the same system name. Otherwise, there was an incorrect entry.

That's what I want to check with Qlikview if possible.

I hope this explanation makes it clear for you.

Thanks in advance,

Frans

Re: Fields compare in relation to quality control

Wed, 01 Aug 2012 11:41:57 GMT

So, add a field in your LOAD script, like I suggested in my previous post.