Combining mid & index

Mon, 26 Oct 2015 12:12:29 GMT

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

Re: Combining mid & index

sunny_talwar — Mon, 26 Oct 2015 15:48:23 GMT

May be this:

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

topic Combining mid & index in QlikView

Combining mid & index

Re: Combining mid & index