Discussion Board for collaboration on QlikView Layout & Visualizations.
i have a straight table with with productnames.
The problem is that some of the products is too long, so they are on a secondline.
Also a problem is that serveral customers has different lenghts on their productnames.
How do i best fit my straight table so there will be only one line?
My expression is :
I have attached an example
one more questions
If i have a productname like this in a bar chart:
How do i split the text up after last )
So in the bar chart it would be
Straight Table: disable multiline values in presentation tab
Bar Chart: subfield(product, ' )', 1) & chr(10) & subfield(product, ' )', 2) or another string-functions like mid/left/right/index ...
the problem is my multiline is set to like 40 lines ( so im sure to get all lines broken down) If i disabled it, i will get 40 products on line like this:
(3489u9343) Mhahahaasds (3489u9343)2 Mhahahaasds (3489u9343)3 Mhahahaasds
And thats not how i want it.
It want it to be:
in my straight table.
But in my bar chart i want:
Perhaps it fit so better ... sometimes are not all requirements simultaneously possible and it should be defined the main-needs ...
Thanks why did you do to the bar chart? I can see that you added Text in chart expression. But how did you get it down from the top?
The straight table aint working as i need, cause i need it to be on another dimension, but thanks anyways i think i have come up with another solution there.