topic Multiple where expressions in QlikView

Multiple where expressions

Fri, 07 Nov 2014 16:25:55 GMT

I am having difficulty ensure that both where query are the same in an expression.

I am trying to do the below command and cant work out what I need to do to ensure both statements are true.

Sum ({$<[period_end]={'31/01/2014 00:00:00'} && [concept_id]={'242'}>} string_value)

Anonymous — Fri, 07 Nov 2014 16:28:42 GMT

Hey ,

use this

Sum ({$<[period_end]={'31/01/2014 00:00:00'},[concept_id]={'242'}>} string_value)

BR,

Chinna