In LOV Values showing double

[#1]

Hi All,

I have exported one report from qlikview into excel - but when we filter the data on perticular field in LOV values are coming double.

please see the below example

   
 
 
 
 
 
 
 
 
 
 
 

[jagan]

Hi Santosh,

Check whether there are any spaces for the values, for example (Applicances) and (Appliances  ).  If there are spaces, then you can trim this by using Trim() in Qlikview dimension or in script.

Hope this helps you.

Regards,

Jagan.

[#3]

Dear Jagan,

Thanks for your reply. But there is no Space in Product Group.

This issue arise only when we export Report from Qlikview to Excel..

Can you please check & suggest.

Best Regards,

Santosh Shigwan

Häfele India Pvt. Ltd.

Office No. 3, Building “A” BETA, I - Think Techno Campus,

Off J.V.L.R, Opp Kanjurmarg Station, Kanjurmarg (E),

Mumbai 400 042, INDIA.

http://www.hafeleindia.com <http://www.hafeleindia.com/>

Customer Care Toll Free: 1800 266 6667 · Email ID: customercare@hafeleindia.com <mailto:customercare@hafeleindia.com>

Santosh Shigwan - Senior Executive - IT

Phone +91 22 6142 6100 · Fax +91 22 6702 0531 Extn 236

mailto:santosh.shigwan@hafeleindia.com <mailto:santosh.shigwan@hafeleindia.com>

[CELAMBARASAN]

Could you please attach sample excel file or Qlikview document?

[#5]

Hi,

Attached Please find the Sample file.

Best Regards,

Santosh Shigwan

Häfele India Pvt. Ltd.

Office No. 3, Building “A” BETA, I - Think Techno Campus,

Off J.V.L.R, Opp Kanjurmarg Station, Kanjurmarg (E),

Mumbai 400 042, INDIA.

http://www.hafeleindia.com <http://www.hafeleindia.com/>

Customer Care Toll Free: 1800 266 6667 · Email ID: customercare@hafeleindia.com <mailto:customercare@hafeleindia.com>

Santosh Shigwan - Senior Executive - IT

Phone +91 22 6142 6100 · Fax +91 22 6702 0531 Extn 236

mailto:santosh.shigwan@hafeleindia.com <mailto:santosh.shigwan@hafeleindia.com>

[CELAMBARASAN]

It looks like you split this string by using some function.

zero width space (Unicode 65279) is appended before the strings.

[#7]

Hi,

What need to do to solve this. Please suggest..

Best Regards,

Santosh Shigwan

Häfele India Pvt. Ltd.

Office No. 3, Building “A” BETA, I - Think Techno Campus,

Off J.V.L.R, Opp Kanjurmarg Station, Kanjurmarg (E),

Mumbai 400 042, INDIA.

http://www.hafeleindia.com <http://www.hafeleindia.com/>

Customer Care Toll Free: 1800 266 6667 · Email ID: customercare@hafeleindia.com <mailto:customercare@hafeleindia.com>

Santosh Shigwan - Senior Executive - IT

Phone +91 22 6142 6100 · Fax +91 22 6702 0531 Extn 236

mailto:santosh.shigwan@hafeleindia.com <mailto:santosh.shigwan@hafeleindia.com>

[#8]

Hi,

We have already used trim function in QVW - what further need to do?

Best Regards,

Santosh Shigwan

Häfele India Pvt. Ltd.

Office No. 3, Building “A” BETA, I - Think Techno Campus,

Off J.V.L.R, Opp Kanjurmarg Station, Kanjurmarg (E),

Mumbai 400 042, INDIA.

http://www.hafeleindia.com <http://www.hafeleindia.com/>

Customer Care Toll Free: 1800 266 6667 · Email ID: customercare@hafeleindia.com <mailto:customercare@hafeleindia.com>

Santosh Shigwan - Senior Executive - IT

Phone +91 22 6142 6100 · Fax +91 22 6702 0531 Extn 236

mailto:santosh.shigwan@hafeleindia.com <mailto:santosh.shigwan@hafeleindia.com>

From: Shigwan, Santosh

Sent: 15 October 2013 13:30

To: 'jive-1752202076-2qdm-2-8pct@qliktech-public.hosted.jivesoftware.com'

Subject: RE: - In LOV Values showing double

Hi,

What need to do to solve this. Please suggest..

Best Regards,

Santosh Shigwan

Häfele India Pvt. Ltd.

Office No. 3, Building “A” BETA, I - Think Techno Campus,

Off J.V.L.R, Opp Kanjurmarg Station, Kanjurmarg (E),

Mumbai 400 042, INDIA.

http://www.hafeleindia.com <http://www.hafeleindia.com/>

Customer Care Toll Free: 1800 266 6667 · Email ID: customercare@hafeleindia.com <mailto:customercare@hafeleindia.com>

Santosh Shigwan - Senior Executive - IT

Phone +91 22 6142 6100 · Fax +91 22 6702 0531 Extn 236

mailto:santosh.shigwan@hafeleindia.com <mailto:santosh.shigwan@hafeleindia.com>

[CELAMBARASAN]

Try something like

If(Ord(Trim(FieldName)) > 1, Right(Trim(FieldName), Len(Trim(FieldName)) - 1))

Or

KeepChar(FieldName , 'ABCDEFGHIJKLMNOPQRSTUVWXYZ abcdefghijklmnopqrstuvwxyz')