Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
QlikView Desktop ----- I am getting font size 11
When I apply same in QlikView
Result: 2
I am expecting result 1.
How can I achieve this?
Thank you.
Regards,
NIHHAL.
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.
Hi Peter,
Thanks for advise. You can see below.
How are you viewing this data in QlikView?
In a Listbox? A Tablebox? Or something else?
Table - straight/pivot.
Did you try to trim() the Product names upon LOADing them from the database?
Yes i tried but not working.
Can you post a screenshot of the chart
Hie Nihhal,
Can you give the sample of data???
Mohammad
