Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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)
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
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
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
So, add a field in your LOAD script, like I suggested in my previous post.