topic Re: Table without Dimensions in QlikView

Table without Dimensions

gr_eldred — Wed, 24 Jan 2018 01:43:43 GMT

Table without Dimensions

Good afternoon there is some way to make a table without dimensions and without leaving a blank column.

This object is a pivot table without dimensions only expressions but it puts an additional column in white which I had to give it some format but at this moment I do not need it, since I need to occupy this table for nprinting.

Can somebody help me?

Re: Table without Dimensions

devarasu07 — Wed, 24 Jan 2018 02:11:18 GMT

Hi,

yes we can do that. simply use the pivot table and then try add all your measure (give one tab space instead of label name) that should return o/p like below

for the text/background color on you measure also u can apply

Re: Table without Dimensions

vishsaggi — Wed, 24 Jan 2018 02:22:19 GMT

If you using only Expression to be visible. Why don't you use straight table and hide the dimension column from Presentation tab.

Re: Table without Dimensions

gr_eldred — Wed, 24 Jan 2018 02:55:18 GMT

Good evening I have my object as you mention it but when using the object in nprinting the empty column requires a blank space

Re: Table without Dimensions

gr_eldred — Wed, 24 Jan 2018 02:58:20 GMT

The reason why I do not occupy a simple table is because nprinting does not let me put the indicators vertically.

When I place the object in the preview, the horizontal table appears

Re: Table without Dimensions

devarasu07 — Wed, 24 Jan 2018 03:33:03 GMT

Hi,

It should work in Nprinting as well. can u share your mock with expected output.

Re: Table without Dimensions

gr_eldred — Wed, 24 Jan 2018 03:49:52 GMT

Hi, I'm using two pivot tables and I have to put them together but they will not let me put them together for the additional column.

Re: Table without Dimensions

gr_eldred — Wed, 24 Jan 2018 03:50:46 GMT

At this time, separate them by a column, but if they do not show an object

Re: Table without Dimensions

devarasu07 — Wed, 24 Jan 2018 04:28:43 GMT

Hi,

best way u can try add all the local calculated measure (using set analysis expression) into one chart (W1,W2, QTD & Total etc) then u can get the fine version of output.

Check this article for the Weekly,QTD expression sample

YTQ, QTD, MTD and WTD

Thanks

Deva