topic Re: make length suitable for straight table in QlikView

make length suitable for straight table

Fri, 16 Aug 2013 09:56:58 GMT

Hello,

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 :

=Concat(DimItem.ProductName,chr(10))

I have attached an example

Re: make length suitable for straight table

Fri, 16 Aug 2013 10:02:10 GMT

one more questions

If i have a productname like this in a bar chart:

(3489u9343) Mhahahaasds

How do i split the text up after last )

So in the bar chart it would be

(3489u9343)

Mhahahaasds

Re: make length suitable for straight table

marcus_sommer — Fri, 16 Aug 2013 10:27:53 GMT

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 ...

- Marcus

Re: make length suitable for straight table

Fri, 16 Aug 2013 10:46:26 GMT

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:

(3489u9343) Mhahahaasds

(3489u9343) Mhahahaasds2

(3489u9343) Mhahahaasds3

(3489u9343) Mhahahaasds4

and not

(3489u9343)

Mhahahaasds

in my straight table.

But in my bar chart i want:

(3489u9343)

Mhahahaasds

Re: make length suitable for straight table

Fri, 16 Aug 2013 11:05:03 GMT

if i use subfield 1, i get all the ids which is correct and if use 2 i get all the names, but i does not make two lines even though i use chr(13)

Re: make length suitable for straight table

marcus_sommer — Fri, 16 Aug 2013 11:08:53 GMT

For me is this not really clear ... best will be you post a small example.

- Marcus

Re: make length suitable for straight table

Fri, 16 Aug 2013 11:23:13 GMT

i have posted an document.

Re: make length suitable for straight table

marcus_sommer — Fri, 16 Aug 2013 13:39:05 GMT

Perhaps it fit so better ... sometimes are not all requirements simultaneously possible and it should be defined the main-needs ...

- Marcus

Re: make length suitable for straight table

nicolai_moller — Fri, 16 Aug 2013 13:46:30 GMT

Hov hov. Lav dine lektier selv

Re: make length suitable for straight table

Fri, 16 Aug 2013 13:55:27 GMT

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.

Re: make length suitable for straight table

Fri, 16 Aug 2013 13:57:11 GMT

Nicolai ? fra asb? Det er jo umuligt at få det ned på 2 linjer.

Re: make length suitable for straight table

marcus_sommer — Fri, 16 Aug 2013 13:57:35 GMT

The text in the bar chart is free text from presentation tab.

- Marcus