topic Re: Issue with Set Analysis expression in App Development

Issue with Set Analysis expression

bhargavikn — Wed, 26 Dec 2018 12:41:43 GMT

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.

Re: Issue with Set Analysis expression

prat1507 — Wed, 26 Dec 2018 12:44:32 GMT

Please use double quotes instead of single quotes.

Regards

Pratyush

Re: Issue with Set Analysis expression

sunny_talwar — Wed, 26 Dec 2018 12:44:52 GMT

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())'}

StartDate = {"<=$(=Today())"}

Re: Issue with Set Analysis expression

bhargavikn — Wed, 26 Dec 2018 12:58:14 GMT

Thanks for reply.

Tried with double quotes also. not working

Re: Issue with Set Analysis expression

bhargavikn — Wed, 26 Dec 2018 12:59:28 GMT

Thanks for the reply.

no environmental variables declared, we are working on binary load from Qlikview

Re: Issue with Set Analysis expression

sunny_talwar — Wed, 26 Dec 2018 13:02:29 GMT

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.

Re: Issue with Set Analysis expression

bhargavikn — Wed, 26 Dec 2018 13:36:41 GMT

Tried as suggested, but not working