Date range Logic working in QV not in QS

[abhaysingh]

Hey Guys,

I have one Date Range Logic which is working in QV but not in QS.. Please Suggest...

logic

=count({<DateSubmitted={'>=$(=vStartDate)<=$(=vEndDate)'}>}SurveyTaskId)

In this i also require if no startdate selected than by default it should give Current Week Data only,

DateSubmitted =  >= weekstart(Today())

Please Advice

THanks

[abhaysingh]

pls revert

[petter]

This logic should work in Qlik Sense as well as long as the surrounding data model and variables are identical.

Be sure that the date format is defined as the same.

Better is to not compare directly with dates formated as strings but as data numbers:

Count( {< DateSubmitted={'>=$(=Num(vStartDate))<=$(=Num(vEndDate))'}>} SurveyTaskId )

[JonnyPoole]

Abhay, are you using 2.1 ?  Variables were introduced into the UI allowing you to create variables with expressions with preceding '=' signs which can change the order of operations. 

What is the exact variable definition in QlikView vs. Qlik Sense ?

If you haven't already, upgrade to 2.1 and manually copy/paste  the expressions for the variables from QlikView to Sense