Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

How to make values in a Pivot Table not to change when making selection

Question:

Im having a problem on my Pivot Table, how can i have Values not to Change when making selection on a Pivot Table

e.g

ProductSales ASales B
Milk150100
Butter2050

Sales A and Sales C are calculated Sum, but how can i have them Not to change when selection is made.

Any function to use?

1 Solution

Accepted Solutions
oknotsen
Honored Contributor III

Re: How to make values in a Pivot Table not to change when making selection

Happy to read your problem is solved.

If that also means this topic is closed, please flag it as answered .

May you live in interesting times!
7 Replies

Re: How to make values in a Pivot Table not to change when making selection

you can "Detach" the whole picot table (I assume it's QlikView and not Qlik Sense...) or you can use a Set Analysis expression to disregard certain selections:

sum( {<Product=>} Sales)

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

Not applicable

Re: How to make values in a Pivot Table not to change when making selection

Hi,

The function you gave it makes the Pivot Table Empty, it disable the Items and Values.

below is my Expression:

sum(aggr( Count(DISTINCT SalesDate), CustomerCode))

Thanks.

oknotsen
Honored Contributor III

Re: How to make values in a Pivot Table not to change when making selection

Hi,

I suggest using Set Analysis.

Try this:

sum({1} aggr( Count(DISTINCT SalesDate), CustomerCode))

May you live in interesting times!
Not applicable

Re: How to make values in a Pivot Table not to change when making selection

Hi Onno,

I just did it Now, seems not working, because now it makes everything Disappear on a Table.

Sample Table:

BEFORE Selection:

Sales OfficerAnswer
David150
Michelle500

AFTER Selection:

Sales OfficerAnswer
David40
Michelle85

The value must remain as 150 not 40.

I Trust this in order you will understand what i want to achieve.

Regards.

oknotsen
Honored Contributor III

Re: How to make values in a Pivot Table not to change when making selection

Can you post some example data on which this table is based?

May you live in interesting times!
Not applicable

Re: How to make values in a Pivot Table not to change when making selection

Hi Onno,

I Discovered the Problem Recently, i was Using Straight Table all along instead an I wrote Pivot Table on my Question, so i changed the table to Pivot, and it worked.

Thanks Again.

oknotsen
Honored Contributor III

Re: How to make values in a Pivot Table not to change when making selection

Happy to read your problem is solved.

If that also means this topic is closed, please flag it as answered .

May you live in interesting times!
Community Browser