Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
prahlad_infy
Creator
Creator

Help my data to limt on the user fed date . Please help .

Helo Seniours ,

I want to show only those data in my table which is of last week to the date selected by me plus next week data

last week data-UserFeddate-Nextweek data .

Thank you in advancing .

12 Replies
tresesco
MVP
MVP

That is because of date format issue you have in your data. Try like:

Sum({<DateE={">=$(=Date(vDateselected-14,'DD/MM/YYYY')) <=$(=Date(vDateselected+14,'DD/MM/YYYY'))"}>}Sales)

prahlad_infy
Creator
Creator
Author

I make change to your given exprns

Sum({<Week={">=$(=vWeekSelected-2) <=$(=vWeekSelected+2)"}>}Sales) and i am selcting 9 jan 2018 then if we minus 2 week , it should get  data from last week of 2017 , but it is not coming

i am fully not understanding sir .

tresesco
MVP
MVP

The problem arises because you are referencing inter-year weeks. For such cases, you should rather use date field along with perhaps weekstart(), weekend() like:

Sum({<DateE={">=$(=Date(WeekStart(vDateselected,-2),'DD/MM/YYYY')) <=$(=Date(WeekEnd(vDateselected,2),'DD/MM/YYYY'))"}>}Sales)

View solution in original post