Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
khaycock
Creator
Creator

Show data from 45 days and over ago

I know this seems quite basic but can't get my head around getting a button to show all data that is dated from 45 days and over ago.

I have the variable vMinus45days=Date(Today()-45,'DD/MMM/YYYY') set up but can't figure out how to get the data that is older than 45 days to show too.

Any ideas?

1 Solution

Accepted Solutions
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

In your button properties->actions->add->Selection->select infield

on Field -> yourFieldDate

on search string -> ='>=$(vMinus45days)'

(FYI my variable is -> vMinus45days = =Date(Today()-45,'DD/MM/YYYY'))

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

8 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

In your button properties->actions->add->Selection->select infield

on Field -> yourFieldDate

on search string -> ='>=$(vMinus45days)'

(FYI my variable is -> vMinus45days = =Date(Today()-45,'DD/MM/YYYY'))

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!
Not applicable

I agree with amartinez35

But bear in mind one thing that is when you load the data you have to make sure that the underneath data is loaded as a date not a string that looks like a date. Otherwise, it won't be comparable.

khaycock
Creator
Creator
Author

Doesn't do anything

Not sure if the formatting of my date makes a difference?

khaycock
Creator
Creator
Author

Yeah I think that might be my problem

Anonymous
Not applicable

Share sample data, so we can help you with the format of data you have.

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

My button :

Capture.PNG

My variable :

Capture.PNG

Help users find answers! Don't forget to mark a solution that worked for you!
khaycock
Creator
Creator
Author

Yeah I have exactly the same stuff but the data isnt changing. I'm thinking it is something to do with date formats maybe but not sure why that would make a difference?

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Can you join your .qvw file ?

Help users find answers! Don't forget to mark a solution that worked for you!