topic Re: Fetch values from 2 files in same table by selecting one button in QlikView

Fetch values from 2 files in same table by selecting one button

markgraham123 — Fri, 26 Jun 2015 17:25:59 GMT

Hi,

I'm trying to do the foront end analytics as follows:

I have SKU, W1, Vel1, WOH1, Pallets and Units from table1,

and

I have SKU, W2, Vel2, WOH2 from table2,

My first table should show me the values:

W1 Pallets Units

My Second table should show me:

W1 SKU(related to W1) Vel2(related. to W2)\

Please find the attached qlikview file.

Re: Fetch values from 2 files in same table by selecting one button

ramoncova06 — Fri, 26 Jun 2015 17:33:21 GMT

not sure I get what you want to do

Re: Fetch values from 2 files in same table by selecting one button

sunny_talwar — Fri, 26 Jun 2015 18:17:27 GMT

Is this what you want?

Used this expression to find average of Vel2 for each each W2:

=Pick(Match(W1, 'A', 'B', 'C', 'D'), Avg(TOTAL {<W2 = {'A'}>}Vel2), Avg(TOTAL {<W2 = {'B'}>}Vel2), Avg(TOTAL {<W2 = {'C'}>}Vel2), Avg(TOTAL {<W2 = {'D'}>}Vel2))

HTH

Best,

Sunny

Re: Fetch values from 2 files in same table by selecting one button

markgraham123 — Fri, 26 Jun 2015 19:00:13 GMT

Hi Sunny,

In a case, where i donot want to take a average (If there were single values so no need to take avg.)

Just wanna display the value of V2 of W2.

Can u pls help me.

Re: Fetch values from 2 files in same table by selecting one button

sunny_talwar — Fri, 26 Jun 2015 19:06:12 GMT

Try this:

=Pick(Match(W1, 'A', 'B', 'C', 'D'), Only(TOTAL {<W2 = {'A'}>}Vel2), Only(TOTAL {<W2 = {'B'}>}Vel2), Only(TOTAL {<W2 = {'C'}>}Vel2), Only(TOTAL {<W2 = {'D'}>}Vel2))

Note: When there is only one value, Sum/Min/Max/Avg/Only will all give you the same value

HTH

Best,

Sunny

Re: Fetch values from 2 files in same table by selecting one button

markgraham123 — Fri, 26 Jun 2015 20:43:53 GMT

U nailed and rocked it again.

Re: Fetch values from 2 files in same table by selecting one button

sunny_talwar — Fri, 26 Jun 2015 20:47:39 GMT

Hahahaha Glad I was able to help

Have a great weekend.

Best,

Sunny