topic Re: How to make values in a Pivot Table not to change when making selection in Qlik Learning Discussions

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

Wed, 11 Mar 2015 11:44:51 GMT

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?

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

Oleg_Troyansky — Wed, 11 Mar 2015 16:58:55 GMT

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!

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

Thu, 12 Mar 2015 06:44:07 GMT

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.

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

oknotsen — Thu, 12 Mar 2015 07:58:42 GMT

Hi,

I suggest using Set Analysis.

Try this:

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

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

Thu, 12 Mar 2015 08:07:10 GMT

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.

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

oknotsen — Thu, 12 Mar 2015 09:42:04 GMT

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

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

Thu, 12 Mar 2015 09:53:14 GMT

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.

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

oknotsen — Thu, 12 Mar 2015 10:24:25 GMT

Happy to read your problem is solved.

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