Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
surajap123
Creator II
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
maxgro
MVP
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


View solution in original post

2 Replies
maxgro
MVP
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


View solution in original post

surajap123
Creator II
Creator II
Author

Thanks !!