1 Reply Latest reply: Oct 6, 2014 2:29 AM by Denis Brajkovic RSS

    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.