Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SAP Connector - How to retrieve only a (key) or a (text) instead of both

Hi Guys,

The script below retrieves for each filed both (Key) and (Text).

How do I modify my script to retrieve only the (Key) or (Text) field?

Thanks in advance,

Aldo.

myTable:

Load *;

Select PseudoMDX D

(

    Dimensions (

   [/XXX/YYY156X] ()   // SCOPE Level 01

   ,[/XXX/YYY401Z] ()  // ENTITY Level 01

   ,[/XXX/YYY6BOZ] ()  // TIME Level 01

               ),

    Slices (

   [/XXX/YYY6BOZ].[2014.01]

            ),

    Measures (

                  [0MEASURES0000000000000009].[/XXX/LSDATA0000000000012]    //LargeSignedData 

              ),

    From ($/XXX/YYYPV4M)

);

0 Replies