Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
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