Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 |
Try this:
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.
Hello.
I believe I was not clear.
The problem is in the calculation of status, the correct values are in excel.
example:
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
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
I tried this, but it did not work.
I'm having trouble finding the right logic to solve the problem.
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.