topic Re: In LOV Values showing double in QlikView

In LOV Values showing double

Sat, 12 Oct 2013 08:50:57 GMT

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

Re: In LOV Values showing double

jagan — Sat, 12 Oct 2013 10:11:09 GMT

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.

Re: In LOV Values showing double

Tue, 15 Oct 2013 05:36:56 GMT

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>

Re: In LOV Values showing double

CELAMBARASAN — Tue, 15 Oct 2013 06:55:07 GMT

Could you please attach sample excel file or Qlikview document?

Re: In LOV Values showing double

Tue, 15 Oct 2013 07:00:07 GMT

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>

Re: In LOV Values showing double

CELAMBARASAN — Tue, 15 Oct 2013 07:09:55 GMT

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

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

Re: In LOV Values showing double

Tue, 15 Oct 2013 08:00:07 GMT

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>

Re: In LOV Values showing double

Tue, 15 Oct 2013 11:36:07 GMT

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>

Re: In LOV Values showing double

CELAMBARASAN — Tue, 15 Oct 2013 11:49:02 GMT

Try something like

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

KeepChar(FieldName , 'ABCDEFGHIJKLMNOPQRSTUVWXYZ abcdefghijklmnopqrstuvwxyz')