topic Re: expression query in QlikView

expression query

Wed, 01 May 2013 13:38:56 GMT

hi all,

i have 2 dimensions and 1 expression:

Date Client Value

T abc 10

T-1 abc 5

T xyz 10

while writting expression

( sum({<Date = T>}[Value]) / sum({<Date = T-1>}[Value] ) -1 as Change

i get output as

Client Change

abc 50%

xyz -

i want to show for xyz change as 100%

please advise

thanks

Gysbert_Wassenaar — Wed, 01 May 2013 14:06:40 GMT

Try: alt(( sum({<Date = T>}[Value]) / sum({<Date = T-1>}[Value] ) -1,1)

Wed, 01 May 2013 14:17:23 GMT

thanks that is working for above scenario

now if for client xyz T value is blank and T-1 is 10

then also i want to show change as -100%

how to go about

Wed, 01 May 2013 15:04:27 GMT

any updates on the above?