Sum Function is not wroking when converting into number

[rockam]

Hi Guys,

I’m not able to aggregate numbers in the table/pivot table /KPI charts in the sheet. I’ve also converted the field’s value to the numeric by using this syntax, but it’s still not working.

.................................................................................................

[Table1]:

LOAD

              [year],

              [month],

Num([impressions]) as [Impression]

FROM [lib://4_QVD (dir_XXXXX)/test.qvd]

(qvd);

...............................................................................................

After loading the data, sum is zero 😞

Any help or suggestion would be appreciated!

Thanks in Advance,

[Vegar · Accepted solution]

Num() is not converting your field into a numeric, it only affects how an numeric value is presented. If the field in question is not recognised as a numeric, then the num() will return a Null value.

If it is not recognised as a numeric then you can try using num#() to make qlik intepret your value as a numeric.

[rockam]

Many Thanks 😊