Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Fields compare in relation to quality control

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.

1 Solution

Accepted Solutions
Not applicable

Re: Fields compare in relation to quality control

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

5 Replies
Not applicable

Re: Fields compare in relation to quality control

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)

2012-08-01_125733.png

Not applicable

Re: Fields compare in relation to quality control

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

Not applicable

Re: Fields compare in relation to quality control

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

Not applicable

Re: Fields compare in relation to quality control

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

Not applicable

Re: Fields compare in relation to quality control

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

Community Browser