Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

mmarco
New Contributor II

how it works in Set Analysis symbol less than and greater than equal?

hi    

how it works in Set Analysis symbol less than and greater than equal?

this function

=count({<Global_assunto = {'1'}, CAL_YEAR={$(=Max(AUT_YEAR))}, AUT_YEAR = >} DISTINCT CODICE_AZDIP)


this no. I added the symbol <= before Max(AUT_YEAR)

=count({<Global_assunto = {'1'}, CAL_YEAR={$(<=Max(AUT_YEAR))}, AUT_YEAR = >} DISTINCT CODICE_AZDIP)


tanks

2 Replies
israrkhan
Valued Contributor II

Re: how it works in Set Analysis symbol less than and greater than equal?

Hi Try like below:


=count({<Global_assunto = {'1'}, CAL_YEAR={<=$(=Max(AUT_YEAR))}, AUT_YEAR = >} DISTINCT CODICE_AZDIP)

or

=count({<Global_assunto = {'1'}, CAL_YEAR={"<=$(=Max(AUT_YEAR))}, AUT_YEAR = >"} DISTINCT CODICE_AZDIP)


or


=count({<Global_assunto = {'1'}, CAL_YEAR={'<=$(=Max(AUT_YEAR))}, AUT_YEAR = >'} DISTINCT CODICE_AZDIP)


Note, If your field [Global_assunto] is integer then dont put like {'1'},

write like [Global_assunto] = {1}..


Hope it helps

Not applicable

Re: how it works in Set Analysis symbol less than and greater than equal?

Hi Marco,

Try the below expression:


=count({<Global_assunto = {'1'}, AUT_YEAR = , CAL_YEAR={ "<= $(=Max(AUT_YEAR))"} >}

DISTINCT (CODICE_AZDIP))