topic Re: Vendor Price Calculation in QlikView

Vendor Price Calculation

Anonymous — Tue, 08 Apr 2014 10:30:26 GMT

Hi Friends,

i am facing one problem,i needed help,i attached the test data,if user selected Year=2014 and Month='Jan',then Max Date of

Jan-2014 is 31-01-2014.i want to display Vensor_Prise value where Transaction_Period<='31-01-2014', and MAX(Transaction_Period) based on vendor_Name and Iten_ID.

based on above condition i want to calculate vendor price value...

Thanks fro your help.

Re: Vendor Price Calculation

MK_QSL — Tue, 08 Apr 2014 10:38:04 GMT

Can you check the Required Result you have mentioned in excel file is right or not?

Re: Vendor Price Calculation

its_anandrjs — Tue, 08 Apr 2014 10:55:38 GMT

Your required result is not please provide more info also check field names.

Regards

Re: Vendor Price Calculation

its_anandrjs — Tue, 08 Apr 2014 11:03:16 GMT

New Update please check now but it is in the backend

Try to load your table like

Temp:

LOAD

[Vendor Name],

ITEM_ID,

EFF_STATUS,

Transaction_Period,

VENDOR_PRICE

FROM

(biff, embedded labels, table is [Test Data$]);

Load

[Vendor Name],

MaxString(Transaction_Period) as Maxdate,

Sum(VENDOR_PRICE) as Sumven

Resident Temp

Group By [Vendor Name];

Let me know if it works for you in the backend and i try to work on the front end.

Thansk & Regards

Re: Vendor Price Calculation

Anonymous — Tue, 08 Apr 2014 11:44:43 GMT

Hi Anand,

Thanks for your replay if you created back end ,it wont be changed based on frend end selections.sorry for before give wrong expected values.

Vendor Name	ITEM_ID	Max Date	Vendor Price
HCUWDKAI-UWGW PPXYGVDKHEXDH BPC.	37031	07/03/2014	0.12
ZHIXAJQEXEU-IJUA	37031	04/03/2011	0.08
LDXG OMDMGXUK	37031	03/12/2012	0.11
DAOIPVNZ UBSMUEBPJ	37031	01/03/2011	0.17
HRIOQ LVWLC AVVZTYARYM US., RCY.	37031	19/03/2014	0.16

Re: Vendor Price Calculation

Anonymous — Tue, 08 Apr 2014 11:45:41 GMT

Thanks Manish,

sorry i given wrong values,

please find below expected result values.

Vendor Name	ITEM_ID	Max Date	Vendor Price
HCUWDKAI-UWGW PPXYGVDKHEXDH BPC.	37031	07/03/2014	0.12
ZHIXAJQEXEU-IJUA	37031	04/03/2011	0.08
LDXG OMDMGXUK	37031	03/12/2012	0.11
DAOIPVNZ UBSMUEBPJ	37031	01/03/2011	0.17
HRIOQ LVWLC AVVZTYARYM US., RCY.	37031	19/03/2014	0.16

Thanks

Re: Vendor Price Calculation

Tue, 08 Apr 2014 13:37:40 GMT

I Don't like it, but it works

My Arkusz1 is "master calendar" you may do in script.

I hope it helps!

regards

Darek

Re: Re: Vendor Price Calculation

Tue, 08 Apr 2014 18:54:26 GMT

Here is version1, with FirstSortedValue.

I think, it should be better

regards

Darek