Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Highlighted
Partner
Partner

Difference Qlik Sense and QlikView set analysis results

Hi,

I am currently migrating a QlikView application to Qlik Sense app. In one of the expression I found, one used in QlikView is not working correctly in Qlik Sense. 

=sum({<History_Date={"$(=weekstart(max((History_Date)),-4))"}>}History_Amount)

QlikView is showing correct result, whereas Qlik Sense is showing 0.

Can anybody help with this issue? Please note this issue is coming in set analysis involving dates.

Regards,

Suhas

 

 

 

3 Replies
Highlighted

Re: Difference Qlik Sense and QlikView set analysis results

Have you checked to make sure that all the environmental variables related to date and time are same between QlikView and Qlik Sense?

Highlighted
Partner
Partner

Re: Difference Qlik Sense and QlikView set analysis results

Hi Sunny,

Thanks for your quick reply. Yes, environmental variables are same. We are maintaining the same script from QlikView application, only the UI is getting changed.

Regards,

Suhas

Highlighted

Re: Difference Qlik Sense and QlikView set analysis results

It would be difficult to know what might be off without having a look... would you be able to share a sample in qvw and qvf to spot the difference