If the script

[#1]

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.

[giakoum]

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

[robert_mika]

Try this:

[#4]

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.

[#5]

Hello.

I believe I was not clear.

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

example:

[giakoum]

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

[robert_mika]

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

[#8]

I tried this, but it did not work.

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

[robert_mika]

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.