Discussion Board for collaboration on QlikView Scripting.
can you tell me, how can I use sum(Amount) by KeyNr, within the last version of it in backend?
I want for example sum(amount) all KeyNr from periode january to july ..
sum(amount)->within only max(version)
try set Analysis
it didnt work
works now without '..'
can you post how your Detail data looks like and what should be expected result?
Now I have the problem, that the versionnr arent the same, by keynr ..
some keynr has version 5 as max, other version 3 as max(version),
so how can I set all max version of several keynr?
sorry I donot understand your requirements
can you post a small example application?
this is the table what I#ve got:
if I use :
It only shows/sum the key within max(versH) --> in this example =7
so, how can I sum all the key with their max(Versh) ?
to get this:
I used a small inline table with your data and I got your final table
please have a look if that's what you want
what I need to sum is not 74.