This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
based on latest s.no the invoice has to sum up sales value
If you have only one value for each SERIAL NO, INVOICE ID and DATE:
INVOICE ID as DIMMENSION
SALES AMOUNT EXPRESSION: FirstSortedValue([SALES AMOUNT], -[SERIAL NO])
DATE EXPRESSION: FirstSortedValue(DATE, -[SERIAL NO])
SERIAL NO EXPRESSION: MAX([SERIAL NO])
Thank you for reply
if want to show it in KPI.How would I show.
But.... which value do you want to show in one kpi? in your example you have one value for each invoice....
If you want to see the sum of the amount:
sum(aggr(FirstSortedValue([SALES AMOUNT], -[SERIAL NO]),[INVOICE ID]))
Note: using aggr will be affected by the dimmensions you use. Is is the case for show in a KPI.