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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Counting users while using Fractile

Hello Experts,

May I request your help  for the following?

I have the following fields

PRODUCT_CODE, USER_ID, BALANCE

I have created a chart with following Parameters

Dimension =  PRODUCT_CODE

Expression1 = Fractile(BALANCE, 0.1)

Expression2 = Fractile(BALANCE, 0.2)

Expression3 = Fractile(BALANCE, 0.3)

Expression4 = Fractile(BALANCE, 0.4)

Expression5 = Fractile(BALANCE, 0.5)

Expression6 = Fractile(BALANCE, 0.6)

Expression7 = Fractile(BALANCE, 0.7)

Expression8 = Fractile(BALANCE, 0.8)

Expression9 = Fractile(BALANCE, 0.9)

Expression10 = Fractile(BALANCE, 1)

I got the chart as follows

DECi3.PNG

Now I want to Count. the user ID's for associated Balance.

If I create a new chart with the following is not working.

DImenion= PRODUCT_CODE

 

Expression1= fractile( TOTAL aggr(count( BALANCE),USER_ID), 0.1)

Expression2= fractile( TOTAL aggr(count( BALANCE),USER_ID), 0.2)

Expression3= fractile( TOTAL aggr(count( BALANCE),USER_ID), 0.3)

How do I count?

Thank you

1 Reply
Not applicable
Author

Please help me.

I have exam data of a class of 50 students.

Now I want to calculate the average (and, median) of top 80% students of that class.

How can I do that?
Please help.

Thanks.