# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for
Did you mean:
Creator II

## Expression result even others are conditional

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??

1 Solution

Accepted Solutions
MVP

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)])

/

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

)

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

2 Replies
MVP

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)])

/

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

)

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

Creator II
Author

Thanks !!