Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hello Every one,
I have this table:
and one calculated key as %LocSuppMat with the combination of first 2 columns.
At the end I want to get a table with
location, supplier, material, Last paid Price.
I have tried the firstsoutedvalue function to calculate "Last Paid Price", but with no success.
=firstsortedvalue(distinct 100*("Invoice Volumn"/"Invoice Quantity"),-date#([INVL.Invoice date],'DD.MM.YYYY'),[%LocSuppMat])
But it shows me "-" in "Last Paid Price"
Anyone has an idea why?
From what I understood, I believe that you're using the Invoice Quantity as the column to get the Last Paid Price you want.
See if the attached QVW helps you, by only considering the last invoice date and summing the Invoice Quantity as shown below, by using set analysis with the [Flag to consider] field equal to 1.