Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm working for Qlikview to Qliksense migration work.
Below expression is from Qlikview, but same is not working in QlikSense.
Expression:
count(distinct {$
<StartDate={'<=$(=Today())'}, EndDate={'>=$(=Today())'},PStartDate={'<=$(=vPeriodDateFrom)'},PEndDate={'>=$(=vPeriodDateFrom)'}>
+<StartDate={'<=$(=Today())'},EndDate={'>=$(=Today())'},PStartDate={'<=$(=vPeriodDateTo)'},PEndDate={'>=$(=vPeriodDateTo)'}>
+<StartDate={'<=$(=Today())'},EndDate={'>=$(=Today())'},PStartDate={'>$(=vPeriodDateFrom)'},PEndDate={'<$(=vPeriodDateTo)'}> }
IF( ('$(=Today())' - PFVacancyDate)>=-30
AND ((PLVacancyDate - PFVacancyDate)>30 OR (PLVacancyDate - PFVacancyDate)=0), ID))
/ (count(distinct {$
<StartDate={'<=$(=Today())'}, EndDate={'>=$(=Today())'},PStartDate={'<=$(=vPeriodDateFrom)'},PEndDate={'>=$(=vPeriodDateFrom)'}>
+<StartDate={'<=$(=Today())'},EndDate={'>=$(=Today())'},PStartDate={'<=$(=vPeriodDateTo)'},PEndDate={'>=$(=vPeriodDateTo)'}>
+<StartDate={'<=$(=Today())'},EndDate={'>=$(=Today())'},PStartDate={'>$(=vPeriodDateFrom)'},PEndDate={'<$(=vPeriodDateTo)'}> }
IF( not IsNull(PFVacancyDate),ID)))
Please help me to resolve the issue ASAP, it is effecting my work.
Thanks a lot in advance.
Please use double quotes instead of single quotes.
Regards
Pratyush
Couple of things to check
1) Is the date format set through environmental variable the same between QlikView and Qlik Sense?
2) May be change the single quotes to double quotes in the expression and see if that works.. for example change from
StartDate = {'<=$(=Today())'}
to
StartDate = {"<=$(=Today())"}
Thanks for reply.
Tried with double quotes also. not working
Thanks for the reply.
no environmental variables declared, we are working on binary load from Qlikview
I don't think the environmental variables get carried over with the use of binary load. Can you copy paste the environmental variable from QlikView to Qlik Sense after the Binary load script in Qlik Sense? Just want to make sure that the base is the same before we compare the results.
Tried as suggested, but not working