topic Need Urgent Help in QlikView

Need Urgent Help

Anonymous — Fri, 20 Nov 2020 18:02:30 GMT

I need urgent help regarding loading data.

My Scenario is:

My Production starts from 7:00 am in the morning till 2:00 am of the Next Day, but i want to show the whole production in the same day like in the mentioned excel file my Production for whole 14/09/2015 which is starting from 14/09/2015 7:00:00 Am till 15/09/2015 2:00:00 AM is 5989.

I want to show the next days two starting hours in the previous day (i.e 14/09/2015).

Please help.

I really need your help urgently.

Thanks and Regards,

Yawar Khan.

Re: Need Urgent Help

m_woolf — Thu, 17 Sep 2015 14:07:54 GMT

if(TimeField<= 2/24,DateField -1,DateField) as Date

Re: Need Urgent Help

Thu, 17 Sep 2015 16:02:02 GMT

Hi Muhammad,

check the attached qvw

Regards

Gennaro

Re: Need Urgent Help

Anonymous — Thu, 17 Sep 2015 18:30:10 GMT

Dear All,

Firstly, i would like to thanks both of you for quick reply.

But the issue is still unsolved.

Gennaro the qvw you have attached shows the correct result for only 13th Sep 2015, but the result for 14th is not correct. It is just calculating the results from 2:00 am to 12:00 am of the same day, i want to calculate the production of the other two hours from 12:00 am to 2 am of 15th Sep into 14th Sep.

Please find the below image for the resultant.

Re: Need Urgent Help

Anonymous — Fri, 18 Sep 2015 06:09:58 GMT

I have resolved the issue

If(Hour(Timestamp)>=2,Date-1,Date) as ProductionDate

Re: Need Urgent Help

Fri, 18 Sep 2015 07:36:58 GMT

I believe that the correct formula is:

if(Hour(Timestamp)<='2', Date(Date-1),Date) as ProductionDate

Regards

Gennaro