topic 4 month back in QlikView

4 month back

mario-sarkis — Fri, 14 Aug 2015 08:59:27 GMT

Hey all ,

Lets say i have this type of Data:

Date ID

Date field has a form as number my requirement i need to extract the data with a condition that the date >= four month back of the (max(date)

Exmple: if my date field has a maximum date as (MM/DD/YYY)'12/3/2015' i need to extract it from '8/3/2015'

Thank you,

Re: 4 month back

MK_QSL — Fri, 14 Aug 2015 09:02:03 GMT

You can use Set Analysis but not clear from your question. Where you want to use this? List Box? Tables or Charts?

Re: 4 month back

mario-sarkis — Fri, 14 Aug 2015 09:10:40 GMT

Hey Manish ,

i need to write it in script ,

i need to extract my data with a condition that my date >= four month back of the (max(date),

hope u can help

Re: 4 month back

sasiparupudi1 — Fri, 14 Aug 2015 09:22:16 GMT

example expression

Sum({$<[Your Date] = {">=$(=Date(AddMonths(Max([Your Date]), -4), 'MM/DD/YYYY')) <=$(=Date(Max([Your Date]), 'MM/DD/YYYY'))"}>} [Your Amount])

Re: 4 month back

mvanlutterveld — Fri, 14 Aug 2015 09:28:35 GMT

Hi,

Create a variable in the script like LET vStartDate = Addmonths(Today(),-4) ;

Extract your table using a Where clause: Where <YourDateField> >= '$(vStartDate)';

If you want your start date variable be based on a maximum date from a table you first have to declare a variable that peeks your max date like: https://community.qlik.com/message/826165#826165