Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Pivot table questions

1) I have a total in my pivot table. But it goes to the top. How do it make it come to the bottom?

2) I have created two pivot tables but when I change the parameter in one pivot table, it changes it on the other. How do i decouple them?

Tags (1)
7 Replies
MVP
MVP

Re: Pivot table questions

1)  On the presentation tab, you can select Subtotals at the Bottom

Capture.PNG

2) Change the Object ID on one of them to un-link them

Capture.PNG

Not applicable

Re: Pivot table questions

How do you get to that screen? All I see is this in my Pivot design

Capture.PNG

MVP
MVP

Re: Pivot table questions

With regard to 2), which parameter are you changing?

If you are using e.g. a dimension group and change the dimension field in one chart, this will also affect all other charts that use the same dimension group (in other words, the current field is a property of the group, not the chart).

Not applicable

Re: Pivot table questions

I am changing a dimension

MVP
MVP

Re: Pivot table questions

Sorry I thought this was QlikView. Not really know how Qlik Sense work

Not applicable

Re: Pivot table questions

Thanks

Not applicable

Re: Pivot table questions

How do I get to the presentation tab?