topic Re: Using Peek in QlikView

Using Peek

joshrussin — Mon, 23 Oct 2017 18:53:15 GMT

Question for using peek.

My data is already sorted by date, latest date is at the bottom.

I am trying to load an equation with peek().

(latest wip - (next to last wip - latest processed))

Here is what I have in my script and is coming up with different values.

(WIP - ((Peek(WIP,-1)) - Processed)) as WIP_Test

any tips or other methods?

Edit*

also tried Previous()

(WIP - ((Previous(WIP)) - Processed)) as WIP_Test

That doesn't work either.

Re: Using Peek

vishsaggi — Mon, 23 Oct 2017 19:04:32 GMT

May be use Peek(WIP, -2)

Re: Using Peek

MarcoARaymundo — Mon, 23 Oct 2017 19:06:36 GMT

Peek('WIP', -1)

Re: Using Peek

vishsaggi — Mon, 23 Oct 2017 19:08:01 GMT

Sorry Missed the Quotes. Just keep quotes around the Fieldname.

Re: Using Peek

joshrussin — Mon, 23 Oct 2017 19:19:09 GMT

Still showing up different values.

Re: Using Peek

vishsaggi — Mon, 23 Oct 2017 19:39:14 GMT

You said latest WIP right?

May be try below?

(Peek(WIP) - ((Peek(WIP,-2)) - Processed)) as WIP_Test

Re: Using Peek

madhumitha — Tue, 24 Oct 2017 09:38:09 GMT

Hello Joshua,

If you are using this in your inline script, then below might help.

(Peek('WIP') - ((Previous(WIP,-1)) - Processed)) as WIP_Test

Re: Using Peek

joshrussin — Tue, 24 Oct 2017 16:09:53 GMT

Here is my file. I can't figure out why its not working correctly.

Re: Using Peek

vishsaggi — Tue, 24 Oct 2017 16:16:54 GMT

Can you share your excel file just for reloading purpose. ?

Re: Using Peek

joshrussin — Tue, 24 Oct 2017 16:19:25 GMT

Here is excel file.

Re: Using Peek

vvira1316 — Tue, 24 Oct 2017 17:05:58 GMT

Hi Joshua,

What is your expected output? How Area, Program, and Date Should be grouped?

BR,

Vijay

Re: Using Peek

joshrussin — Tue, 24 Oct 2017 17:39:24 GMT

I am trying to get an average WIP inbound per client for the last 30 days. The table following this is showing the clients in Mechanical Inspection for the last 30 days and a total.

I am also trying to get a current month daily inbound line graph as follows

I am just trying to figure out how to create the "WIP Inbound" column in Qlik rather than computing it in excel first.

Re: Using Peek

vishsaggi — Tue, 24 Oct 2017 18:12:17 GMT

Check this? Let me know if this is not what you looking for.

I created two variable for Max and Previous max of WIP.

vWIP = Max(WIP) - --> Max of WIP

vWIP2nd = Max(WIP, 2) ---> 2nd Max of WIP

Expression will be like.

WipTesting:

Load

WIP,

$(=vWIP) - ($(=vWIP2) - Processed) as WIP_Test

Resident WIP_Raw_Data

;

Re: Using Peek

joshrussin — Tue, 24 Oct 2017 18:21:57 GMT

The Avg(WIP_Test) should be the same as the "Average Inbound" that is already the third column in the sheet.

Re: Using Peek

vishsaggi — Tue, 24 Oct 2017 19:02:47 GMT

Sorry can you explain a little. Why they both should be? Can you take one example and let me know for that specific Client name what should be your value for WIP_Test field. ?

Can you explain the expr you are trying to use for WIP_Test please?

Re: Using Peek

joshrussin — Tue, 24 Oct 2017 19:26:38 GMT

If you look at the raw data file itself, there is only one row per client per day.

If you look at the output from the file you provided, there are multiple for each day instead of each day.

So that would throw off the average.

Re: Using Peek

vvira1316 — Wed, 25 Oct 2017 05:03:59 GMT

Hi Joshua,

I got you PrevWIP for each record. I've small error that I'm trying to find and fix it. Let me know if this will work for you.

The error is that for some reason in table I got only 12326 records even though processing was for all records. I'm looking into it.

I think there are duplicates. that is causing the difference in record count from original.

Re: Using Peek

joshrussin — Wed, 25 Oct 2017 13:44:07 GMT

I think this should work, I will look at it in a little while, few things to catch up on here, but after looking at your pics closer, the WIP Inbound is correct. Thanks man.

Re: Using Peek

vvira1316 — Wed, 25 Oct 2017 15:17:19 GMT

Hi Joshua,

Script processing may not be needed if we can come up with set analysis expression for Min Date record of each Area, Program combination. For that records we can ignore PrevWIP in WIPInbound calculation. Otherwise we have to use it. This is after PrevWIP value has been added in the table. This will allow to drop FOR LOOP processing that I've in the script. FOR LOOP slows down little bit.

I hope what I'm saying here makes sense and hope it will work.

BR,

Vijay