Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
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
Hi,
Please see the attachment , and change value of variables according to ur requirement.
Thanks,
AS
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
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
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
I have foun on community It means I m searcing before I ask!!!
'>' & date(now()-14) & '<= ' & date(now())
Glad to know it worked
I'm happy for you.
Regards
ASHFAQ
='>' & date(max(ANSWERTIME)-10,'DD.MM.YYYY hh:mm:ss') & '<= ' & date(max(ANSWERTIME),'DD.MM.YYYY hh:mm:ss')