Issue with Pivot table

shahnaz0794 — Fri, 30 Apr 2021 09:33:31 GMT

Hello Team

While working on Pivot table it was seen that bullet separated sentences are not getting separated in the pivot tale.

Ideally the separated lines should be visible in next line or row but the same is not happening.

The tooltip is showing correct but the same is not reflecting in the pivot table.

Please let me know how can the same be achieved. Please look into the image for clarity

Expression used is: =Replace([Fiscal Year Goal], chr(10),chr(10)&chr(10)&'•')

Thank you

Shahnaz

Re: Issue with Pivot table

Bessieey — Wed, 05 May 2021 04:03:45 GMT

@PrepaidGiftBalance wrote:
Hello Team
While working on Pivot table it was seen that bullet separated sentences are not getting separated in the pivot tale.
Ideally the separated lines should be visible in next line or row but the same is not happening.
The tooltip is showing correct but the same is not reflecting in the pivot table.
Please let me know how can the same be achieved. Please look into the image for clarity
Expression used is: =Replace([Fiscal Year Goal], chr(10),chr(10)&chr(10)&'•')

Thank you
Shahnaz

There is a restriction in databases that fields can't have numeric names, or at least not start with a number or underscore but this is dependent on the database type. Allthough you see numbers the field Thn_Buat_u must be text as it contains multiple values and commas. Can you explain more about what you're expecting from this pivot table? Perhaps it would be better to do this in Excel or similar due to fuzzy types in spreadsheets.

topic Issue with Pivot table in QlikView

Issue with Pivot table

Re: Issue with Pivot table