topic Advanced If:ing in QlikView

Advanced If:ing

Mon, 22 Nov 2010 14:08:29 GMT

LOAD * INLINE [

date, Value

1, 20

1, 30

2, 10

2, 15

3, 40

3, 11

];

This question is part of a more complex expression but here is a simplified version of where it fails:

sum(if(date = max(date), value) => null

is there some other way to accomplish the same?

Advanced If:ing

Mon, 22 Nov 2010 14:12:37 GMT

LOAD * INLINE [

date, Value

1, 20

1, 30

2, 10

2, 15

3, 40

3, 11

]

WHERE sum(if(date = max(date), value) >=Null();

Advanced If:ing

Mon, 22 Nov 2010 14:32:44 GMT

the expression is used in the app not when loading data. here is just some example data, its just something to test an expression on.

Advanced If:ing

Miguel_Angel_Baeyens — Mon, 22 Nov 2010 15:06:19 GMT

It may be a typo, but there is one parenthesis missed there

sum(if(date = max(date), Value))

Besides, names are case sensitive in QlikView. I'd rather try

sum({< date = {'$(=max(date))'} >} Value)

Hope this helps

Advanced If:ing

Mon, 22 Nov 2010 16:10:41 GMT

I realise My explanation was quite bad.

The expression resides in a chart and has to calculate separatly for each row due to a third field which i did not include here, So there can be No set analysis since they calculate once for the entire chart. so is there any way to write the expression in ifs? (with correct case of course)

Advanced If:ing

Miguel_Angel_Baeyens — Mon, 22 Nov 2010 16:13:02 GMT

If you only want to get the maximumd date, then something like this should work

If(date=max(TOTAL date), Sum(Value))

Hope that helps.