Discussion Board for collaboration related to QlikView App Development.
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.
Can you check the Required Result you have mentioned in excel file is right or not?
Your required result is not please provide more info also check field names.
New Update please check now but it is in the backend
Try to load your table like
(biff, embedded labels, table is [Test Data$]);
MaxString(Transaction_Period) as Maxdate,
Sum(VENDOR_PRICE) as Sumven
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
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.
sorry i given wrong values,
please find below expected result values.
I Don't like it, but it works
My Arkusz1 is "master calendar" you may do in script.
I hope it helps!
Here is version1, with FirstSortedValue.
I think, it should be better