Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Valued Contributor II

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
Highlighted
Valued Contributor II

Re: Date range Logic working in QV not in QS

pls revert

Highlighted
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 )



Highlighted
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