Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
shahamel
Creator
Creator

firstsortedvalue calculation

Dear QV Users,

I have a question concerning firstsortedvalue,

I want to calculate this:

sum VERBINTENIS_NUMMER order by

     KWALIFICATIE_NIVO

     BEKOSTIGD

     OMVANG_OPLEIDING

     ISNULL(DATUM_UITSCHRIJVING, DATUM_GEPLAND_EINDE)

     VERBINTENIS_NUMMER

i think it is something like this but it does not work correctly:

sum({$<Date={">=$(=VERBINTENIS_NUMMER(firstsortedvalue(TOTAL <KWALIFICATIE_NIVO,BEKOSTIGD,OMVANG_OPLEIDING,ISNULL(DATUM_UITSCHRIJVING, DATUM_GEPLAND_EINDE)),VERBINTENIS_NUMMER> VERBINTENIS_NUMMER,-

VERBINTENIS_NUMMER),'DD/M/YYYY'))"}>}VERBINTENIS_NUMMER)

Gr. Sandeep

0 Replies