Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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.
Many Thanks 😊