Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Not applicable

Converting from Text to Number

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.

1 Reply
dbc
New Contributor III

Re: Converting from Text to Number

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.

Community Browser