Not correct

[#1]

Whats wrong in this formula? I think the hooks are not on the correct place. Who can halp me?

='PRICE WEEK ' &MAX(JAAR) & CHR(10) & NUM(SUM({<JAAR={"$(=MAX(JAAR))"},%Date={"<=$(=ADDYEARS(MAX(%Date),-1))"}>}([SOMETHING]/100))

+

sum({<JAAR={"$(=MAX(JAAR))"},%Date={"<=$(=ADDYEARS(MAX(%Date),-1))"}>}(
If(REKENING=8094,
(([THING])/100)-(([SO])/100)
,0)))
+
(sum(
If(REKENING=8194,
(([THING])/100)-(([SO])/100)
,0))
&
(
If(REKENING=8294,
(([THING])/100)-(([SO])/100)
,0)))



/


(count(DISTINCT([WEEK])))


,'€ #.##0;€ -#.##0') 

[MayilVahanan · Accepted solution]

Hi

May be try like this

'PRICE WEEK ' & MAX(JAAR) & CHR(10) &

NUM(
(
SUM({<JAAR={"$(=MAX(JAAR))"},%Date={"<=$(=ADDYEARS(MAX(%Date),-1))"}>}([SOMETHING]/100))
+

sum({<JAAR={"$(=MAX(JAAR))"},%Date={"<=$(=ADDYEARS(MAX(%Date),-1))"}>}(
  If(WildMatch(REKENING,8094,8194,8294),(([THING])/100)-(([SO])/100),0)))
)

/(count(DISTINCT [WEEK]))

,'€ #.##0;€ -#.##0') 

[#3]

Thanks it is correct!

[p_verkooijen]

edit: See that the answer was allready added before this comment. Should you want to analyze the issue do :

Split this expression in seperate expressions in a Chart to isolate the incorrect part.

Second don't use a expression label in the chart, when you hover over the label it wil show the calculated contents of the expression (i.e. $(=YEAR(Today())) wil be shown as 2015 .

[Qlik_learner_developer]

Hello all,

I am new to qliksense,
Can you please share qvf  or qvw file for betsy bikes app.