Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to create a document which is fetching LME Metal price for last 5 years. The data is fetching perfectly as expected.
I have created a Calendar object for both start date and end date by defining two variables vStartDate and vEndDate. When I am selecting the dates from February Month, the selection is not being made and hence no data is being changed on the basis of the selection from calendar object.
I tried to find out where can be the error, so I created a List Box for the date field and found out that all the dates are right aligned except the dates pertaining to February which were left aligned. There is the problem in that area. Since I am very new to Qlik View, I urgently need your help in this area. I understand that February month is unique in that it will have either 28 days or 29 days. I think this fact has something to do with this problem. Here I would like to mention that I have used Date# in the script to make the date field as per my desired format.
I hope you will help me to solve this problem.
I understand that February month is unique in that it will have either 28 days or 29 days. I think this fact has something to do with this problem.
Perhaps, that(No of days) woulld NOT be the reason of your problem. Please check in your source data if the dates of February are differently formatted and so Date#() can't read it as date.
when you create calendar object qlikview automatically syncronise with calendar , here is problem is not with february month ,,,
reduce data and attach the sample of only that object ...lets c
Hello Sir,
I am attaching herewith my QV document containing data form 1st January till date.
I have selected dates of February in both the calendar objects. As you can see that the Table Box does not reflect the changes in the Calender object. You can go through the script behind it. I have done modifications in the script so that display of the data be as per my requirement. I have applied Date# to the Date field in addition to Replace command.
When I select though List Box after creating it, it works (Although the dates of February are left aligned as against right alignment of other months dates), but I am not able to create the Calender object for the purpose of selection. As per my understanding I have applied date format to 'DD-MMMM-YYYY' every where to have similarity.
Please suggest me what to do.
Thanx
Manish Prasad
Check your source data. Your February values are spelled 'Febuary', missing an 'r'
That's why the date parsing does not work for those values.
Yes, Stephan has rightly pointed out.
PFA for workaround as you can't modify the source data.
Use expression:
Date(MakeDate(Right(date,4),Num(Month(Date#(mid(date,5,3),'MMM'))),Left(date,2)),'DD-MMMM-YYYY') as Date