Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
aheavy95
Creator
Creator

measure values change based on row selections

Hi all 
I am running into a weird problem.

In a table chart ,  there is an order column and a measure.

For order ID  7660163, when no orders are filtered, the measure equals 0  (it should be 1)

aheavy95_1-1678878926216.png

and once I filter this specific Order ID I get 1 in the measure- which is what I should get 

aheavy95_2-1678879283767.png

 same thing applies for more Order Id's 

this is the measure calculation in case it helps

aheavy95_3-1678879432754.png

Appreciate your help

 

 

 

Labels (5)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Aggr by both OrderID and UserEmail at the moment it’s only aggregating by useremail

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

Aggr by both OrderID and UserEmail at the moment it’s only aggregating by useremail

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
aheavy95
Creator
Creator
Author

Thant helped thanks a lot