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

[#1]

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

Product	Sales A	Sales B
Milk	150	100
Butter	20	50

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?

[Oleg_Troyansky]

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!

[#3]

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]

Hi,

I suggest using Set Analysis.

Try this:

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

[#5]

Hi Onno,

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

Sample Table:

BEFORE Selection:

Sales Officer	Answer
David	150
Michelle	500

AFTER Selection:

Sales Officer	Answer
David	40
Michelle	85

The value must remain as 150 not 40.

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

Regards.

[oknotsen]

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

[#7]

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 · Accepted solution]

Happy to read your problem is solved.

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