topic Re: to fix straight table width with many dimensions in QlikView

to fix straight table width with many dimensions

laujerry — Fri, 30 Sep 2016 03:12:46 GMT

my aim is to fix the width of the straight table and provides a horizontal scrollbar for user

the problem is that the chart has many dimensions, and scrollbar only starts from the expression position

so the chart is "expanded" by the dimension list and goes beyond the screen edge

i have gone thru a lot of posts but still don't find a proper solution yet

- moving dimensions to expression (for some reason i cant reproduce the same result so i give up this)

- drag a dummy expression to the left of first dimension (this can treat qv to show the scrollbar starting from first column, but still cannot restrict the width of table due to existing of many dimensions)

- put the chart into a container and a horizontal scrollbar will be available (i tested that this works in webview only, but when the app is deployed to access point, the scroll bar disappeared again)

is there a better solution available now? thanks

Re: to fix straight table width with many dimensions

trdandamudi — Fri, 30 Sep 2016 03:42:28 GMT

Can you share a sample app with few rows to take a look...

Re: to fix straight table width with many dimensions

varshavig12 — Fri, 30 Sep 2016 03:55:28 GMT

Is it OK, if you change the style of your straight table ?

Like below,

Or may be someone can provide you with a better alternative.

Re: to fix straight table width with many dimensions

nagarjuna_kotha — Fri, 30 Sep 2016 05:00:23 GMT

Hi Jerry,

If want Scroll bar for all your dim, then drag one expression before one dim and if you can ,i ll give you scroll all columns.

If you are not able to do it .Provide sample file and i ll tell u how to do it.

-Nagarjun

Re: to fix straight table width with many dimensions

nagarjuna_kotha — Fri, 30 Sep 2016 05:07:54 GMT

Check attched.

I hope this may helps you.

-Nagarjun

Re: to fix straight table width with many dimensions

avinashelite — Fri, 30 Sep 2016 05:36:41 GMT

Good Idea nagarjuna.kothamandi‌ , Just to add a bit add one dummy expression and hide the same from Presentation tab so that you will have better look and feel

Re: to fix straight table width with many dimensions

laujerry — Fri, 30 Sep 2016 05:50:50 GMT

hi varsha, i think this can not solve my problem, thanks

Re: to fix straight table width with many dimensions

varshavig12 — Fri, 30 Sep 2016 05:53:30 GMT

I thought so, No problem.

Now you have other options. Try them.

Re: to fix straight table width with many dimensions

laujerry — Fri, 30 Sep 2016 06:05:14 GMT

hi nagarjuna,

this is mentioned in one of my finding above already, but the problem is that i have a long list of dimensions, and i need my chart width to be fixed within the screen

you cannot resize your chart to e.g. 10px only, because the minimum width of the chart will need to be at least showing all the dimensions and roughly one or two expressions

so your solution can enable the scrollbar but cannot restrict the width of the chart

in my another suggestion, putting the chart into a container solves the problem in web view but the scollbar disappears again when being deployed to accesspoint

Re: to fix straight table width with many dimensions

Wed, 03 May 2017 10:31:00 GMT

Hi,

Try this one...

I've used a solution like your first one, but with some changes:

Don't "Move" dimension field (expression instead of dimension ) -

You need to Add the dimension also as an expression.

Then, you need to hide the dimension field. (solves data errors).

Hope it will help to you too

Regards,

Netanel