topic Re: error in expression in QlikView

error in expression

kunkumnaveen — Wed, 02 Mar 2016 06:58:07 GMT

Hello guys

Is there any thing wrong with this expression,

i took two straight table ,one on top and other at bottom

the top table has dimension :name1 and there related expression

so the requirement was,when i select a value from the name1 field then that selected value related qm_score has to display on the bottom straight table ,else if none value are selected from the top table .......the bottom table should show either 0 or empty space

to achieve the above task i wrote this expression ,unfortunately it throwing me an error

if(GetSelectedCount(name1)>0,FirstSortedValue({<ROLE={'SELF_EVALUATOR'}>}QM_SCORE, -DATE_OF_REVIEW,0 )

thanks

naveen

Re: error in expression

tresB — Wed, 02 Mar 2016 07:06:04 GMT

Try like:

if(GetSelectedCount(name1)>0,FirstSortedValue({<ROLE={'SELF_EVALUATOR'}>}QM_SCORE, -DATE_OF_REVIEW)

i.e - remove '0' (sort-weight is expected >0)

Re: error in expression

kunkumnaveen — Wed, 02 Mar 2016 07:11:39 GMT

Hello Tresesco

i tried ur expression....but its says ERROR IN EXPRESSION

if(GetSelectedCount(name1)>0,FirstSortedValue({<ROLE={'SELF_EVALUATOR'}>}QM_SCORE, -DATE_OF_REVIEW)

Re: error in expression

tresB — Wed, 02 Mar 2016 07:14:16 GMT

Sorry, missed your IF error (no closing brace). Try:

if(GetSelectedCount(name1)>0,

FirstSortedValue({<ROLE={'SELF_EVALUATOR'}>}QM_SCORE, -DATE_OF_REVIEW)

)