topic Re: Values change when making selection on a Pivot Table in QlikView

Values change when making selection on a Pivot Table

Thu, 12 Mar 2015 07:51:58 GMT

Hi All Experts,

I have a table that has values in, but when selecting on an Item, the values change

any idea to solve that matter?

Sample Table:

BEFORE Selection:

Name	Answer
Office	50
Employee	10

AFTER Selection:

Name	Answer
Office	3
Employee	16

Thanks.

PrashantSangle — Thu, 12 Mar 2015 07:55:36 GMT

Hi,

Is there any relation between them??

If you dont want to change the value after selection of item then your pivot table expression nullify that field

Sum({<item=>}Answer)

Regards