Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
sivarajs
Specialist II
Specialist II

Trying to combine two expressions

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

3 Replies
perumal_41
Partner - Specialist II
Partner - Specialist II

Hi Siva,

Is possible to upload sample application

sivarajs
Specialist II
Specialist II
Author

Its huge one, also secured. I cant upload here

perumal_41
Partner - Specialist II
Partner - Specialist II

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)))