Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MauriceLudo
Creator II
Creator II

aggr set analysis

Bonjour,

quelqu'un s'il vous plait peut vérifier  la syntaxe de cette expression /

num(aggr(sum({$<TYPE= {'VO'},AOC= {'oui'}>} RE_FLAG_)),DATE_ENTREE_STOCK), '# ##0')

merci

2 Replies
antoniotiman
Master III
Master III

Hi Maurice,

correct syntax

num(aggr(sum({$<TYPE= {'VO'},AOC= {'oui'}>} RE_FLAG_),DATE_ENTREE_STOCK), '# ##0')

I remove ')'

However, if doesn't work, try

num(Sum(aggr(sum({$<TYPE= {'VO'},AOC= {'oui'}>} RE_FLAG_),DATE_ENTREE_STOCK)), '# ##0')

Regards,

Antonio

flochi75
Creator III
Creator III

Antonio a raison,

la parenthèse était mal placée ,

j'ai testé et ça marche

=num(sum(aggr(sum({$<VEHICULE_TYPE= {'VO'},RE_REPRISE_AOC= {'oui'}>} RE_FLAG_REPRISE),VEHICULE_DATE_ENTREE_STOCK)),'###0')

mais ça ramène 0...

Florent