Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
pls revert
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 )
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