Values change when making selection on a Pivot Tab... - Qlik Community

Report Inappropriate Content · ‎2015-03-12

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 · ‎2015-03-12

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

like

Sum({<item=>}Answer)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Values change when making selection on a Pivot Table