topic Re: Trying to combine two expressions in QlikView

Trying to combine two expressions

sivarajs — Wed, 12 Nov 2014 12:56:43 GMT

Hi,

I am trying include second expression in first but am not getting any result

First Expression:

if(GetFieldSelections(DateMode)='AND',

count(1),

if(GetFieldSelections(DateMode)='OR' and $(vVar)= 0 and $(vVar1)=0 ,

count(1),

count({

RWNO =$(vRow)

>}1)))

Second Expreesion:

Count({< Status={'APP'},Type={'RE'}>}1) (this actually exclude selection other than APP and RE)

Regards,

Siva

perumal_41 — Wed, 12 Nov 2014 13:00:48 GMT

Hi Siva,

Is possible to upload sample application

sivarajs — Wed, 12 Nov 2014 13:11:28 GMT

Its huge one, also secured. I cant upload here

perumal_41 — Wed, 12 Nov 2014 13:17:09 GMT

Hi Siva,

Try below expression

if(GetFieldSelections(DateMode)='AND',

Count({< Status={'APP'},Type={'RE'}>}1) if(GetFieldSelections(DateMode)='OR' and $(vVar)= 0 and $(vVar1)=0 ,

Count({< Status={'APP'},Type={'RE'}>}1),

count({

RWNO =$(vRow)

>}1)))