topic Re: textboxformula in QlikView

textboxformula

Frank_Hartmann — Thu, 08 Oct 2015 10:43:14 GMT

Hi QV Community,

I need to show up one value in a textbox but until now i´ve missed to configure the textboxformula in a proper way!

I have attached a qvw file.

anyone able to help?

thanks in advance

Re: textboxformula

rubenmarin — Thu, 08 Oct 2015 10:46:31 GMT

Hi Frank, try with:

=Sum(Aggr(

if(sum({$<MonthDiff={[$(vAktuellerMonat)]}>}Daten_Recherchen)>=$(vValue) and atan2(linest_m(aggr(sum({$<MonthDiff={'>=$(vZeitraum6Monate)<=$(vAktuellerMonat)'}>}Daten_Recherchen),AWS_Recherchen,MonthNumber),MonthNumber),1)/Pi()*180<>0 ,

if(atan2(linest_m(aggr(sum({$<MonthDiff={'>=$(vZeitraum6Monate)<=$(vAktuellerMonat)'}>}Daten_Recherchen),AWS_Recherchen,MonthNumber),MonthNumber),1)/Pi()*180>atan2($(vGrenze),1)/Pi()*180,1,0),0), AWS_Recherchen))

Re: textboxformula

gautik92 — Thu, 08 Oct 2015 10:47:37 GMT

what is that value 12??

Re: textboxformula

Frank_Hartmann — Thu, 08 Oct 2015 10:51:10 GMT

thank you soo much