Converting from Text to Number

Sun, 05 Oct 2014 18:57:18 GMT

I connected MS OLAP cube and able to get measures and other attributes successfully into Qlik Sense., but my “[Measures].[PatientMaster Count]” is showing as Text. Or not allowing me to create a measure. Is it possible to change my value to Measure?

I am ok to load the data first in QVD and change data while I am re-loading the data in my dashboard.

I tried many things including responses in this thread as well. Nothing is working so far.

http://community.qlik.com/thread/54213

OLEDB CONNECT TO [Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TestCube;Data Source=400-bdiqs-slq-100;Location=400-bdsql-p-003];

SELECT NON EMPTY { [Measures].[PatientMaster Count], [Measures].[Therapy Count] } ON COLUMNS, NON EMPTY xxxxxxxxxxxxx

Thanks for your help.

Re: Converting from Text to Number

Denis_Brajkovic — Mon, 06 Oct 2014 06:29:14 GMT

This little example should works and result in numeric values (as mentioned in http://community.qlik.com/thread/54213 😞

LOAD *,

num( EVALUATE([Measures].[PatientMaster Count]),'#0') AS PatientMaster Count

SELECT NON EMPTY { [Measures].[PatientMaster Count], [Measures].[Therapy Count] } ON COLUMNS, NON EMPTY xxxxxxxxxxxxx

Also check the data model viewer for that specific field. It should be tagged as $numeric $integer.

topic Converting from Text to Number in Connectivity & Data Prep

Converting from Text to Number

Re: Converting from Text to Number