Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

abhaysingh
Contributor III

Date range Logic working in QV not in QS

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

3 Replies
abhaysingh
Contributor III

Re: Date range Logic working in QV not in QS

pls revert

MVP
MVP

Re: Date range Logic working in QV not in QS

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 )



Employee
Employee

Re: Date range Logic working in QV not in QS

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

Community Browser