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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
perry7
Contributor
Contributor

Modular Result in a Pivot Table - Calculate the Result when i 've reached up 85% of a odd variable - Fractile

Hi!
 I've made an histogram where I see:
- Numbers of Packages
- Time (Lead Time from Arrived to Shipping)

I need to study the Lead Time when i 've reached up 85% of numer packages ordered by Lead Time Ascendend 
(see picture under)
  

perry7_0-1651475817966.png

 

 

I've to put this result on Pivot Table, where i have categories variables as Area, Store, Region, Package Type, Good Type...

The formula of my goal is:
=Max({< [LeadTime]={"<= $(=fractile([Lead Time],0.85))"} >} [Lead Time])

 

But if I put it in a Pivot, I ve :

perry7_1-1651475817969.png

 

The result is not modular when i change  the categories variables, but its always the same!
What shall I write ??

Hoping a solution,
marco

perry7_2-1651475818022.png

 

 

 

0 Replies