Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
QSense
Contributor II

selection with button

Hello,

I have one date column and I would like to make select with button for ten days

date column's format DD.MM.YYYY 00:00:00

In search string I wrote ;

date(SALE_DATE,'DD.MM.YYYY') >=date(VMaxDate-10,'DD.MM.YYYY')

8 Replies

Re: selection with button

Hi,

Go through this post once. It shows how to do that.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/06/dynamically-selecting-timeframes

Regards

ASHFAQ

amit_saini
Honored Contributor III

Re: selection with button

Hi,

Please see the attachment , and change value of variables according to ur requirement.

Thanks,

AS

QSense
Contributor II

Re: selection with button

I think You are witing this post to gain points

What does it mean? Go through this post once. It shows how to do that.

Do not I know before searching in community

Re: selection with button

Hi qliekview

I read your thread fully and I gave you robust solution for your requirement.

Just to let you know that the idea from the community is to help each other and not to make others work.

Its requirement for you not me you need to Spend some time and do practice, rather then posting questions.

There are many more alternatives available.

By the way for your information there is limit to point we get on each reply.

We earn only 20 points for reply per day.

The other points are coming from correct and helpful answers.

Hope its clear.

Regards

ASHFAQ

amit_saini
Honored Contributor III

Re: selection with button

Qliekview,

It's not about earning point my friend  , sometimes sharing links on community save time and efforts.

I do agree with Ashfaq.

Thanks,

AS

QSense
Contributor II

Re: selection with button

I have foun on community It means I m searcing before I ask!!!

'>' & date(now()-14) & '<= ' & date(now())

Re: selection with button

Glad to know it worked

I'm happy for you.

Regards

ASHFAQ

QSense
Contributor II

Re: selection with button

='>' & date(max(ANSWERTIME)-10,'DD.MM.YYYY hh:mm:ss') &  '<= ' & date(max(ANSWERTIME),'DD.MM.YYYY hh:mm:ss')

Community Browser