topic Re: If the script in QlikView

If the script

Wed, 21 Jan 2015 15:24:37 GMT

Dear,

I need help.

Need to create a Dimension Calculated or in my script the calculation below, however I'm not getting.

In copy excel to illustrate what I'm talking about.

Re: If the script

giakoum — Wed, 21 Jan 2015 15:37:13 GMT

something like that ?

Filial	STATUS	Sum([Itens Total])	sum([Itens Estoque])	sum([itens Liberados])
		59.033	7.404	51.629
CRAVINHOS	BLOQUEIO PARCIAL	37.279	2.39	34.889
CRAVINHOS	BLOQUEIO TOTAL	14.754	2.914	11.84
CRAVINHOS	SEM BLOQUEIO	7	2.1	4.9

Re: If the script

robert_mika — Wed, 21 Jan 2015 15:42:14 GMT

Try this:

Re: If the script

Wed, 21 Jan 2015 15:42:39 GMT

Hi,

I see you have to move Status to rows, because now you have it in columns. Just "drag and drop" label "status" and try to move it to rows.

Second thing - in Excel you have 2 expressions, and in QV you must have also 2 expressions (in table properties, on Expression tab, click "Add" button and write second expression):

Sum([itens Liberados])

Sum([Itens Estoque])

See the attached file.

Re: If the script

Wed, 21 Jan 2015 16:05:55 GMT

Hello.

I believe I was not clear.

The problem is in the calculation of status, the correct values are in excel.

example:

Re: If the script

giakoum — Wed, 21 Jan 2015 16:12:42 GMT

these two are exactly the same :

IF ( ([Itens Total] - [itens Liberados]) = [Itens Estoque], 'BLOQUEIO PARCIAL',

IF ( ([Itens Total] - [Itens Estoque]) = [itens Liberados], 'SEM BLOQUEIO',

so for the same if, you try to apply 2 different values. It will always be the first I guess

Re: If the script

robert_mika — Wed, 21 Jan 2015 16:37:26 GMT

Fallowing your logic from Excel file Try this in your script

IF ([Itens Total] = [Itens Estoque], 'BLOQUEIO TOTAL',

IF ( [Itens Total] - [itens Liberados]=[Itens Estoque] AND IsNull([Itens Estoque]), 'BLOQUEIO PARCAIL',

IF([Itens Total]-[itens Liberados] =[Itens Estoque], 'BLOQUEIO TOTAL'))) AS STATUS

Re: If the script

Wed, 21 Jan 2015 17:04:42 GMT

I tried this, but it did not work.

I'm having trouble finding the right logic to solve the problem.

Re: If the script

robert_mika — Thu, 22 Jan 2015 11:31:51 GMT

In your Excel file Column J2

=H2+I2

drag down

In your .qwv file change the IF statement to

IF ( [Itens Total] = [Itens Estoque], 'BLOQUEIO TOTAL',

IF ( [Itens Total] = [itens Liberados],'SEM BLOQUEIO', 'BLOQUEIO PARCAIL'

)) AS STATUS

For some reason when the Total was enter as number not as formula QLikview wrongly calculated the totals.