Discussion Board for collaboration related to QlikView App Development.
I have a doubt, I'd like show a KPI the highest month in sales:
I'd like to answer 2 Question at least:
1.- What's the month with more sales (In Products)?
2.- What's the month with more sales (In Amount)?
What I'm looking for is a function to solve and get this one:
In a textbox?
try something like
=Maxstring( Aggr( dual(Month & ' ' & Money(Sum(Amount)), Sum(Amount)), Year., Month))
=Maxstring( Aggr( dual(Month & ' ' & Num(Sum(Products)), Sum(Products)), Year., Month))
View solution in original post
Simply... You're the best, Stefan...
Thank you very much...