Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
vmoreno2605
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)
1 Solution

Accepted Solutions
vmoreno2605
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!
1 Reply
vmoreno2605
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!