Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Limiting data in table by last x days

Hello,

I'm new to Qlikview so forgive me for any ridiculous questions.

I have a table containing account details (username, email, country etc.). I also have a field in the table which is the date when the account was created.

Is it possible to have an input box which takes a number of days (x), and only displays the number of accounts in the table which have been created in the last 'x' number of days?

Thanks in advance for any help,

Peter

3 Replies
Not applicable
Author

hello

have a look at the attached example.

It mays help.

Regards

Gilles

Not applicable
Author

Thanks so much for your response, that's exactly what I was looking for.

Just one more query though, where and how do you set the variable 'V_limit_date'?

Thanks again,

Peter

Not applicable
Author

You can create the variable in the menu Settings / Variable overview

Then use this variable when you create the slider

Gilles