topic Re: How to include data from day before in QlikView

How to include data from day before

joshrussin — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to create a formula that will be the equivalent of this.

Selected_Date - (Day_Before_WIP - Current_Processed)

Trying to display the data within this graph

This is what the table looks like.

Re: How to include data from day before

vishsaggi — Wed, 26 Jul 2017 18:41:35 GMT

May be this ?

SelectedDate - (Sum({< Date = { "$(= Date(Date(DateField, 'MM/DD/YYYY') -2) )" } WIP) - Sum(CurrentProcessed))

Re: How to include data from day before

joshrussin — Wed, 26 Jul 2017 19:46:24 GMT

I tried this and nothing is coming up

Sum(WIP) - (Sum({< "Date" = { "$(= Date(Date(DateField, 'MM/DD/YYYY') -2) )" } WIP) - Sum(Processed)))

Sorry, to explain the equation a little better, I need the Sum of Today's WIP "WIP" minus the result of

(Yesterday's WIP - Today's Processed)

I need it to show up in the pivot table like above. Thanks

Re: How to include data from day before

vishsaggi — Wed, 26 Jul 2017 20:01:15 GMT

Can you share a sample to look into and did you change the datefield with your actual date field name. May be try this?

Sum(WIP) - (Sum({< "Date" = { "$(= Date(Date(Date, 'MM/DD/YYYY') -2) )" } WIP) - Sum(Processed)))

Re: How to include data from day before

joshrussin — Wed, 26 Jul 2017 20:54:04 GMT

Here is a sample of what I have. If you go to the sheet there is the pivot table.

this is the correct output, but with hard coded values. I am trying to figure out how to make qlik do the math portion rather than excel.

Re: How to include data from day before

vishsaggi — Wed, 26 Jul 2017 21:47:43 GMT

This is Qlik Sense right? I will have to look into it later.

Re: How to include data from day before

joshrussin — Wed, 26 Jul 2017 21:51:09 GMT

Thank you, Yes it is Qlik sense. I appreciate it very much.

Re: How to include data from day before

vishsaggi — Thu, 27 Jul 2017 15:01:22 GMT

I have changed the measure expression can you check if the values are coming out correctly?

Attached the qvf file.

Re: How to include data from day before

joshrussin — Thu, 27 Jul 2017 15:18:59 GMT

Data is showing, but it is not correct. I don't think it is getting yesterday's data correctly.

If you filter by mechanical inspection - lots

here are the correct results

Re: How to include data from day before

vishsaggi — Thu, 27 Jul 2017 15:36:02 GMT

Is this the same working file you sent me or a different one?

Re: How to include data from day before

joshrussin — Thu, 27 Jul 2017 15:57:16 GMT

The picture I sent was of a working file, but the values were created in excel. I am trying to get Qlik to do the work instead of manually doing the calculations in excel