topic Not correct in QlikView

Not correct

Wed, 15 Apr 2015 08:08:14 GMT

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')

Re: Not correct

MayilVahanan — Wed, 15 Apr 2015 08:27:50 GMT

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')

Re: Not correct

Wed, 15 Apr 2015 08:35:24 GMT

Thanks it is correct!

Re: Not correct

p_verkooijen — Wed, 15 Apr 2015 08:57:24 GMT

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 .

Re: Not correct

Qlik_learner_developer — Thu, 20 May 2021 17:23:55 GMT

Hello all,

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