topic Re: Font Issue in QlikView

Font Issue

nihhalmca — Fri, 20 Feb 2015 07:50:25 GMT

Hi All,

Example:

Database has table Product and filed name as Product name.

Product Name

QlikView Server

QlikView Publisher

QlikView Desktop ----- font size 11

QlikView Desktop ---- font size 12

When I write query in database as select Distinct Product Name from Product:

Result: 1

Product Name

QlikView Server

QlikView Publisher

QlikView Desktop ----- I am getting font size 11

When I apply same in QlikView

Result: 2

Product Name

QlikView Server

QlikView Publisher

QlikView Desktop ----- font size 11

QlikView Desktop ---- font size 12

I am expecting result 1.

How can I achieve this?

Thank you.

Regards,

NIHHAL.

Re: Font Issue

Peter_Cammaert — Fri, 20 Feb 2015 07:55:17 GMT

Usually, people looking for assistance put a clear question in their first post. Not everyone has MS Word available on their device.

When loading database records, use trim() to delete any leading or trailing spaces from all product names.

Re: Font Issue

nihhalmca — Fri, 20 Feb 2015 08:01:27 GMT

Hi Peter,

Thanks for advise. You can see below.

Example:

Database has table Product and filed name as Product name.

Product Name

QlikView Server

QlikView Publisher

QlikView Desktop ----- font size 11

QlikView Desktop ---- font size 12

When I write query in database as select Distinct Product Name from Product:

Result: 1

Product Name

QlikView Server

QlikView Publisher

QlikView Desktop ----- I am getting font size 11

When I apply same in QlikView

Result: 2

Product Name

QlikView Server

QlikView Publisher

QlikView Desktop ----- font size 11

QlikView Desktop ---- font size 12

I am expecting result 1.

How can I achieve this?

Regards,

NIHHAL.

Re: Font Issue

Colin-Albert — Fri, 20 Feb 2015 08:12:50 GMT

How are you viewing this data in QlikView?

In a Listbox? A Tablebox? Or something else?

Re: Font Issue

nihhalmca — Fri, 20 Feb 2015 08:47:51 GMT

Table - straight/pivot.

Re: Font Issue

Peter_Cammaert — Fri, 20 Feb 2015 08:51:00 GMT

Did you try to trim() the Product names upon LOADing them from the database?

Re: Font Issue

nihhalmca — Fri, 20 Feb 2015 09:26:03 GMT

Yes i tried but not working.

Re: Font Issue

Colin-Albert — Fri, 20 Feb 2015 09:28:16 GMT

Can you post a screenshot of the chart

Re: Font Issue

mohammadkhatimi — Fri, 20 Feb 2015 10:25:14 GMT

Hie Nihhal,

Can you give the sample of data???

Regards,

Mohammad