topic Re: Create Data Table in QlikView

Create Data Table

Mon, 25 Mar 2013 11:28:41 GMT

Hey,

I need some help create in Qlikview a table, that I will later use to build a chart. As Dimension in my chart I want "Name of the error" and as Expression "Number of errors".

Name of the error	Number of errors
Error 1	56
Error 2	36
Error 3	23

The problem is that "Number of errors" must be calculated with an expression like this (example for error 1).

count

(if(Testserie=1and((L_Z1V1+L_Z1V2+L_Z2V1+L_Z2V2+L_Z3V1+L_Z3V2+L_Z4V1+L_Z4V2)/8)<MW_Bank_OG, L_Z1V1))

(Testserie, L_Z1V1... are Data that I have already uploaded to Qlikview)

Depending on the chosen period of time, "Number of errors" must change automatically.

Can you please help me with this task??? Thank you in advance!

Eduardo

Re: Create Data Table

alexandros17 — Mon, 25 Mar 2013 11:39:02 GMT

you have not mentioned how your data is linked to time period, if an error is linked to a date, simply add the date to the dimensions and it should work.

letme know

Re: Create Data Table

Mon, 25 Mar 2013 11:42:58 GMT

Hey,

Thats an example of my original table:

Time	Testserie	LZ1V1	LZ1V2
16.02.2013	1	0,5	0,4
16.02.2013	1	0,3	0,45
17.02.2013	1	0,5	0,3

Errors are not linked with date... In fact errors have to be calculated with the values of LZ1V1 LZ1V2 etc.

Does it help you?

Thank you very much for your help!

Eduardo

Re: Create Data Table

alexandros17 — Mon, 25 Mar 2013 12:32:25 GMT

ok but test series happens in a certain date, as I told you before add the date in a multi box or as dimension, it works.

Re: Create Data Table

Mon, 25 Mar 2013 12:40:03 GMT

But my dimension should be "Name of the error", not "Date"... How can I solve this?

Thank you!

Eduardo

Re: Create Data Table

alexandros17 — Mon, 25 Mar 2013 12:44:12 GMT

OK then add to your report a Multi Box object where the field is "Time".

By selectiong a time , only series taken in that time will be taken.

You can also create calendar selector ....

Let me know if it works.

Re: Create Data Table

Mon, 25 Mar 2013 12:46:16 GMT

I understand it, but the thnig is that the table

Name of the error	Number of errors
Error 1	56
Error 2	36
Error 3	23

doesn´t exist. I have to create it, and I don´t know how.

Thank you!

Eduardo

Re: Create Data Table

alexandros17 — Mon, 25 Mar 2013 13:02:48 GMT

Well, let's start again:

the testserie number identify the error number, is this correct?

If this is true then

1) create a chart (straight table) with testserie as dimension (you can call it Error in the description)

2) create an expression like sum(L_Z1V1+L_Z1V2+L_Z2V1+L_Z2V2+L_Z3V1+L_Z3V2+L_Z4V1+L_Z4V2)/8); values will be automatically divided by testserie and date

3) add a multi box with the date

....

Let me know

Re: Create Data Table

Mon, 25 Mar 2013 14:11:29 GMT

Sorry Alex but Testserie doesn´t identify the error. I have 8 different types of error and each line can have all of them (more than one at the same time is possible). With L_Z1V1, L_Z1V2... I have to proof which errors has this line.

Thank you very much for your help and sorry but this subject is quite complicated.

Eduardo