selection with button

[QSense]

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')

[ashfaq_haseeb]

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]

Hi,

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

Thanks,

AS

[QSense]

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

[ashfaq_haseeb]

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]

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]

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

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

[ashfaq_haseeb]

Glad to know it worked

I'm happy for you.

Regards

ASHFAQ

[QSense]

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