Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
khaycock
Contributor

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?

Tags (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: Show data from 45 days and over ago

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

View solution in original post

8 Replies
Partner
Partner

Re: Show data from 45 days and over ago

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

View solution in original post

Not applicable

Re: Show data from 45 days and over ago

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
Contributor

Re: Show data from 45 days and over ago

Doesn't do anything

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

khaycock
Contributor

Re: Show data from 45 days and over ago

Yeah I think that might be my problem

payalgosar
Contributor II

Re: Show data from 45 days and over ago

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

Partner
Partner

Re: Show data from 45 days and over ago

My button :

Capture.PNG

My variable :

Capture.PNG

khaycock
Contributor

Re: Show data from 45 days and over ago

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?

Partner
Partner

Re: Show data from 45 days and over ago

Can you join your .qvw file ?