Skip to main content

Qlik

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
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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: 
Not applicable
‎2012-12-12 10:50 AM

Filter Selections

Hi All,

I currently have 2 graphs which give me the 25th and 99th percentile of order cycle time. The Dimension is Closed Month and the expression is

  

Fractile

(Status_WorkingHours_Cal,0.99)

which works. But the user wants to be able to type in different numbers which in turn will change the percentile of the graph. For example they could time in 20 and 90 and the two graphs will change to show the 20 percentile in one and the 90 percentile in the other. Is it possible to do this?

 

237 Views
0 Likes
2 Replies
Not applicable
‎2012-12-12 11:09 AM
Author

You can do it with a variable as an input box.  Just make your formula Fractile(Status_WorkingHours_Cal,$(VariableName))

162 Views
0 Likes
Not applicable
‎2012-12-12 11:11 AM
Author

In response to

Also, it may be easier for the user for them to enter an integer in the input box, then you could have a second variable divide that variable by 100 and refer to the second variable in your formula.  Just a thought.

162 Views
0 Likes