Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Combining mid & index

Hi

I am extracting data from SQL Server getting Distinct Fund name

LOAD Distinct("Fund_Name");
SQL SELECT "Fund_Name"
FROM "FI_Dashboard".dbo."VR_Data"
WHERE "FUND_NAME" NOT IN ('NO_OF_FUNDS')
order by "Fund_Name";

=mid(Fund_Name, 1, index(Fund_Name, ' ')-1)

Using mid & index, I am getting the value from the Fund Name

ie., Axis Short Term Fund --> 'Axis'

But I am getting a blank field on Top (image attached).  How to avoid this blank column.

Mukundan

1 Reply
Highlighted

May be this:

If(Len(Trim(mid(Fund_Name, 1, index(Fund_Name, ' ')-1))) > 0, mid(Fund_Name, 1, index(Fund_Name, ' ')-1))