Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
gr_eldred
Contributor II

Table without Dimensions

Table without Dimensions


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


pivote4.png
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?

8 Replies
devarasu07
Honored Contributor II

Re: Table without Dimensions

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

Capture.JPG

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

Capture.JPG

vishsaggi
Esteemed Contributor III

Re: Table without Dimensions

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

gr_eldred
Contributor II

Re: Table without Dimensions

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

pivot6.png

gr_eldred
Contributor II

Re: Table without Dimensions

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

devarasu07
Honored Contributor II

Re: Table without Dimensions

Hi,

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

Capture.JPG

gr_eldred
Contributor II

Re: Table without Dimensions

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.

prueba1.png

prueba2.png

gr_eldred
Contributor II

Re: Table without Dimensions

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

devarasu07
Honored Contributor II

Re: Table without Dimensions

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