# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
New Contributor III

## Set Analysis two conditions

Hi People, i need your wisdom please!

I have the following code: Count({<FechaNum={"<=\$(vFecha)>=\$(vFechaInicioAño)"},HireTerm={'H'}>}Distinct EMPLOYEE)

It works perfect, as you can see in this part FechaNum={"<=\$(vFecha)>=\$(vFechaInicioAño)"} i use two conditions, and it works perfect however i have this expression: sum ({<Fecha={"<=\$(vFecha)<\$(=Makedate(\$(vAño),1))"}>}total DiferenciaFecha) and here: Fecha={"<=\$(vFecha)<\$(=Makedate(\$(vAño),1))"} i tried the same and it is not working.

Can anybody explainme how this works? Because my understanding of this is Fecha=<=\$(vFecha) and Fecha=<Makedate(\$(vAño),1)

Am i wrong? Any Ideas? Thanks a lot!

Labels (3)

• ### Set Analysis

1 Solution

Accepted Solutions
New Contributor III

## Re: Set Analysis two conditions

I solved it!!!

It does not work the way thought, for example in this expression:
sum ({<Fecha={"<=\$(vFecha)<\$(=Makedate(\$(vAño),1))"}>}total DiferenciaFecha)
the way it works is: Fecha<=\$(vFecha) and \$(vFecha)<Makedate()

The first one worked perfect because accidentally i wrote it correctly.

Thanks anyway!