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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Florida78
Contributor
Contributor
‎2020-08-26 09:54 PM

Quartile Measure

 Hi, 

I am a new user. I have a table Sale, location, EmployeeName, and other column.  I added a pivot table, under dimension - add location. Measure I would like to add Q1,Q2,Q3 and Q4.   I used the below formula for Q1 Measure

Q1 = Sum(Aggr(If(Sum(NCH) >= Max(TOTAL <SkillGroup_Location> NCH) * 0.75,Sum(NCH)),SkillGroup_Location,AssociateName))

I am error in expression. 😞

Can anyone help me? Please 

 

 

Labels (1)
Labels
612 Views
0 Likes
0 Replies