topic Re: Expression Issue in QlikView

Expression Issue

Thu, 18 Aug 2016 14:57:11 GMT

Hi,

I was wondering why the condition in this expression for a measure is not valid?

count({<left(adjmt_id ,2) = '05'>} adjmt_id)

Thanks,

Ben

m_woolf — Thu, 18 Aug 2016 15:32:50 GMT

You can use IF:

count(if(left(adjmt_id ,2) = '05', adjmt_id))

Or you can create a new field in script:

left(adjmt_id ,2) as NewField;

Then:

count({<NewField = {'05'}>} adjmt_id)

Anonymous — Thu, 18 Aug 2016 15:37:36 GMT

I think you can NOT Evaluate or do functions ON THE LEFTSIDE of Modifiers ...

But anyway

check with this

count({<left(adjmt_id ,2) = {"05"}>} adjmt_id)

count({<adjmt_id={"=left(adjmt_id,2)=05"}> adjmt_id)