topic Re: Wrapping Column in report in QlikView

Wrapping Column in report

qlikviewwizard — Sun, 05 Jul 2015 07:16:35 GMT

Hi All,

I want to show same value of the column only once as shown in screen.

How to wrap the column?

Current Format:

Required Format:

Re: Wrapping Column in report

marcus_sommer — Sun, 05 Jul 2015 09:03:57 GMT

It's not possible in qv to format an object like in excel. Therefore you need a workaround to come so nearby as possible. One possibility ist to calculate the percentage as an additional field within the script and used it as a normal dimension within the chart. Another possibility could be to calculate these percentage as calculated dimension within the chart.

Otherwise you could use a common "dirty" workaround by using several object beside or overlapping each other - in this case maybe with a textbox which contained the percentage.

- Marcus

Re: Wrapping Column in report

Kushal_Chawda — Sun, 05 Jul 2015 10:49:58 GMT

Can you post sample app?

Re: Wrapping Column in report

shambhub — Sun, 05 Jul 2015 11:47:11 GMT

Hi,

Use Pivot table and put Percentage column in the first.

Best Regards

Shambhu B

Re: Wrapping Column in report

robert_mika — Sun, 05 Jul 2015 11:53:25 GMT

It is not wrapping but custom format:

Try like this:(i do not have your data so some fake one)

First:

Second:

Third:

My expression used:

=if(Grade='40-50',10,'')