Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
vmoreno2605
Creator
Creator

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
Creator
Creator
Author

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!

View solution in original post

1 Reply
vmoreno2605
Creator
Creator
Author

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!