Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm new to Qlik sense and I'm struggling to make it up and ready but seems I'm missing something except I checked the implementation of NumericalAbbreviation and for me it's Ok but seems not working !
Can someone tell me what I'm missing here ? thanks
Finally I get where the issue comes from :
My db is a MS SQL 2017 and actual / Budget are defined as Money. When I went through the Data Manager I saw that my numbers are preceded by " ' ". I don't know why ??? The workaround I put in place is to create calculated field that force actual to numerical value by multiplying it by 1 and then of course NumericalAbbreviation worked fine.
Any insight why in Qlik Sense my db money values are preceded by " ' " ?