Calculation inside of a diagramm / chart

[Anonymous]

Hello,

I have the following problem:

I have a Table with different states and time linked to this state

State	Duration
State_1	1
State_2	1.5
State_3	45
State_3	2

What I did was putting the State as dimension and sum(Duration) as formula.

The problem now is , that I have to split the State_3 in 3 other substates.

I tried the following: I put the State our of dimentions and added every State as formula

(If(State=State_1;sum(duration);0)

and called the formula State_1.

Unfortunatly QlikView is showing me always 0 as the result..

Any idea?

Cheers chesterluck

[#2]

Hi,

why don't you add another subdimension as State_3_1, State_3_2...

You can then display States 1, 2, 3 as total or see split states if you develop your graph

Christian

[Anonymous]

QV uses commas instead of semicolons in if statements.

Also, if you have an expression with if(<test>,sum(<value>)) then the test is carried out across all the rows, not for each value in the field. Try instead sum(if(<test>,<value>)) to do a test at a record by record level.

Jonathan

[Anonymous]

@Jonathan: I used of course commas in the formula - otherwise it wouls show a syntax error..

@Christion: I can surely do it in the loading process (probably I will), but I thought that such things can also be done in the chart itself...

Cheers chesterluck

[Anonymous]

@Jonathan: I used of course commas in the formula - otherwise it wouls show a syntax error..

@Christion: I can surely do it in the loading process (probably I will), but I thought that such things can also be done in the chart itself...

Cheers chesterluck

[Anonymous · Accepted solution]

How about the second point about the sum(if... vs. if(sum... ordering ? Does that help.

Jonathan

[Anonymous]

and sum(if worked

Thx a lot