topic Re: Expression result even others are conditional in QlikView

Expression result even others are conditional

surajap123 — Thu, 03 Jul 2014 15:54:19 GMT

Hi All,

I have these 3 exprssions in my straight table. I made the column 1 and 2 as conditional(enable conditional checkbox in exprssion tab). So due to this my 3rd expression is not working.

1. sum({<Year=, Quarter=, Month=, field=p({$<Year=, Quarter=, Month=>} field)>} sales)])

2. sum({<Year=, Quarter=,Month=,field=p({$<Year=, Quarter=,Month=>} field) >} sales)])

3. if ( Column (2) = 0 , '-' , column(1) / column (2) )

How can i write the 3rd expression(or some settings), so that it will show values all the time??

Re: Expression result even others are conditional

maxgro — Thu, 03 Jul 2014 17:00:06 GMT

maybe

if(

sum({<Year=, Quarter=,Month=,field=p({$<Year=, Quarter=,Month=>} field) >} sales)])=0,

'∞',

sum({<Year=, Quarter=,Month=,field=p({$<Year=, Quarter=,Month=>} field) >} sales)])

)

itsn't clear to me why you have expr1 = expr2

Re: Expression result even others are conditional

surajap123 — Fri, 04 Jul 2014 12:27:04 GMT

Thanks !!