topic Re: selection with button in QlikView

selection with button

QSense — Wed, 01 Oct 2014 06:37:35 GMT

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

Re: selection with button

ashfaq_haseeb — Wed, 01 Oct 2014 06:41:00 GMT

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

Re: selection with button

amit_saini — Wed, 01 Oct 2014 06:44:45 GMT

Hi,

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

Thanks,

Re: selection with button

QSense — Wed, 01 Oct 2014 06:44:58 GMT

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

ashfaq_haseeb — Wed, 01 Oct 2014 07:00:38 GMT

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

Re: selection with button

amit_saini — Wed, 01 Oct 2014 07:08:57 GMT

Qliekview,

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

I do agree with Ashfaq.

Thanks,

Re: selection with button

QSense — Wed, 01 Oct 2014 08:00:29 GMT

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

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

Re: selection with button

ashfaq_haseeb — Wed, 01 Oct 2014 08:06:31 GMT

Glad to know it worked

I'm happy for you.

Regards

ASHFAQ

Re: selection with button

QSense — Thu, 02 Oct 2014 12:44:07 GMT

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