Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I'm hoping this is a simple answer. I have a Set Analysis query which is pulling through worker shift information to see if they have used our clocking in device:
Count({$<LogInKiosk = {'Yes'}}>}$VisitReference)
This works all fine, however I want to be able to only look at visits before today. I have a variable called vLogDate which returns the correct date but when I add it to the following
Count({$<LogInKiosk = {'Yes'},, VisitStartDate = {"<=$(vLogDate )}>}$VisitReference)
It doesn't return any information.
Any help would be great.
James
You need to have a closing double quote in your expression:
Count({$<LogInKiosk = {'Yes'}, VisitStartDate = {"<=$(vLogDate)"}>} $VisitReference)
Also, make sure that the variable has the right date format. https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511
HIC
You need to have a closing double quote in your expression:
Count({$<LogInKiosk = {'Yes'}, VisitStartDate = {"<=$(vLogDate)"}>} $VisitReference)
Also, make sure that the variable has the right date format. https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511
HIC
Ahhh the missing quotation!!!!
Thank you, all sorted now 🙂