This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi! I need to compare 2 dates in order to count how many employees are at some time.
I have a pivot table with month and year as dimensions.
if(date(Fecha) >= date(leg_fecing,'MM/dd/yyyy'), Count(leg_numero)- Count (leg_fecegr))
It's not working. How can i solve this?
Hi @carotravaglini , please try something like this :
Hi @Qfabian, thanks for the answer. I've got some results with your reply, but wrong ones.
Hi, checking your original formula, maybe it is like this:
Thank you @QFabian , i found a solution with this formula and your idea was really helpfull:
count(distinct(leg_numero)) - count(distinct(if([leg_fecegr.autoCalendar.Date]<[Fecha.autoCalendar.Date],leg_numero))) - count(distinct(if([leg_fecing.autoCalendar.Date]>[Fecha.autoCalendar.Date],leg_numero)))