Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Josh_Good
Employee
Employee

Selecting Arbitrary Date Ranges

Learn how to make arbitrary date range selections using a from and to date selection.

http://www.youtube.com/watch?v=UTDyO68BYL8

39 Replies
fashid
Specialist
Specialist

Hi Josh,

Thank you for replying.

I had posted this discussion in the forums and got the same reply.

Thank you so much for this post, i completed a requirement all thanks to your contributions.

Have a nice day.

Regards,

Nadeem Shaikh

kanve_03
Contributor II
Contributor II

HI need to create a extra column in calender which has

week(TempDate) As week

Month(TempDate) As Month,

// one more column has Period (which should have only week or month)

as in below screen shot where ever month starts it should be month

if not it should week

month.PNGWeek,


Not applicable

Hi Josh,

How can i select arbitrary date ranges from Multibox(Year,quater,month,day)..Can you please share any qvw or video to implement...

sample3.png

Thanks

Venkat

sujeetsingh
Master III
Master III

AWESOME

Not applicable

Hi Josh,

Thanks a lot for the sharing. I'm recently exploring QlikView again for another project. I tried follow the steps shared in your video but still I can't get it to work. I'm stuck at the 4.05 of your video where you demo by entering some date into the input field of start date and enter it. For my case, there is no changes happen (not even at 'current selection').

I'm wondering what is the issue. Here, I'm attaching the file. Hope you can advice.

Thanks!

Not applicable

HEy Josh,

thank you for the video! It helps me very much.

But i have an question:

What is if the user set vEndDate before the vStartDate or on the other way round?

i want to put something like this somewhere, but i don't know or where:

if(vStartDate>vEndDate, vEndDate, vStartDate) for vStartDate

and

if(vEndDate<vStartDate, vStartDate, vEndDate) for vEndDate

best

Thanks!

Josh_Good
Employee
Employee
Author

Hi RG,

I'm glad you find the video helpful.  I like your enhancement of adding this logic.  You would do this in the expression for the action trigger when the variable is changed (2:38 in the video Selecting Arbitrary Date Ranges - YouTube).

-Josh

Qlik

Not applicable

hey Josh,

thank you for your answer!

i tried this solution but it dont work... maybe you have another idea?

I have another Question:

I put three Buttons to change the Date directly for 3 month, 1 year and 2 years beginning with today.

At the buttons config i put an action (extern -> set variable)  and change the variable of vStartDate and vEndDate with value like this: "vStartDate" & "=Date(today(1)-91)" -> 3 month and "vEndDate" & "= Date(today(1))"

The ScrollerBar changes the value and also the CalendarBox. But in the diagramm it changes nothing.

the strange thing is, that it work in develope mode but in webview it doesnt work... do you know why?

Not applicable

Guys I have tried everything to make this work but all in vain.

Selection Box indicates that the values in this range are selected but selections are not reflected in the list box. Even the data is not reduced. I have tried converting the variables and dates in same format and what not.

Please help me out.

Selection.JPG

LB.JPG

gwassenaar‌ I hope you would have an idea on why is this not working.

Your efforts are highly appreciated.

Thanks

Not applicable

Hi Josh,

Thanks for the video. It's really awesome one.

I used the same in my project. It is working, but as per the user requirement, on document open, the dates 01-APR-2016 to today date should be selected. So I used Document Event Triggers>> On Open>> V_STARTDATE='01-APR-2016' AND V_ENDDATE=TODAY(). It is working, it is selecting the dates in ORDER_DATE field but the issue is it is not reflecting in the calendar object. (Calendar object is showing blank on document open).

Is there any way to do that? Thanks in advance.