Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
greend21
Contributor II

Hide Dimension in Pivot Table or Show Blanks for Repeating Dimensions

Right now I am trying to set up three pivot tables right next to eachother with the same dimensions of date and payment type so I would like to hide the dimensions on the 2nd and 3rd tables. Does anyone know how this is possible? The issue is that the column categories needed for it to be one pivot would be difficult to throw into the data model, so we wanted to go this route.

Another option is to just use a straight table since I can add in all of the measures but I would like to hide repeating dimension values. I have the paid Vizlib extensions available for use as well but did not see any options for either situation. For example, if we have checks and wires I want it look like this

5/19/2019PaymentType1###$$$
 PaymentType2###$$$
 PaymentType3###$$$
 PaymentType4###$$$

 

and not this

5/19/2019PaymentType1###$$$
5/19/2019PaymentType2###$$$
5/19/2019PaymentType3###$$$
5/19/2019PaymentType4###$$$

 

EDIT: The pivot would be preferable because I need subtotals by date.

 

2 Replies
Partner
Partner

Re: Hide Dimension in Pivot Table or Show Blanks for Repeating Dimensions

Go to the chart properts > Presentation section and flag the "Fully expanded" option.

greend21
Contributor II

Re: Hide Dimension in Pivot Table or Show Blanks for Repeating Dimensions

Well if I stick to a pivot table I actually want to hide the date and payment type dimensions from view but still have the measures displayed as if they were fully expanded so that they all line up.

The layout examples I provided would be a straight table so there wouldn't be any expanding.