Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Vendor Price Calculation

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.

7 Replies
Highlighted
MVP
MVP

Re: Vendor Price Calculation

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

Highlighted

Re: Vendor Price Calculation

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

Regards

Highlighted

Re: Vendor Price Calculation

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

Highlighted
Creator III
Creator III

Re: Vendor Price Calculation

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 NameITEM_IDMax DateVendor Price
HCUWDKAI-UWGW PPXYGVDKHEXDH BPC.3703107/03/20140.12
ZHIXAJQEXEU-IJUA3703104/03/20110.08
LDXG OMDMGXUK3703103/12/20120.11
DAOIPVNZ UBSMUEBPJ3703101/03/20110.17
HRIOQ LVWLC AVVZTYARYM US., RCY.3703119/03/20140.16
Highlighted
Creator III
Creator III

Re: Vendor Price Calculation

Thanks Manish,

sorry i given wrong values,

please find below expected result values.

Vendor NameITEM_IDMax DateVendor Price
HCUWDKAI-UWGW PPXYGVDKHEXDH BPC.3703107/03/20140.12
ZHIXAJQEXEU-IJUA3703104/03/20110.08
LDXG OMDMGXUK3703103/12/20120.11
DAOIPVNZ UBSMUEBPJ3703101/03/20110.17
HRIOQ LVWLC AVVZTYARYM US., RCY.3703119/03/20140.16

Thanks

Highlighted
Not applicable

Re: Vendor Price Calculation

I Don't like it, but it works

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

I hope it helps!

regards

Darek

Highlighted
Not applicable

Re: Re: Vendor Price Calculation

Here is version1, with FirstSortedValue.

I think, it should be better

regards

Darek