Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
oscarmqz
Creator III
Creator III

Any way to make this formula work?

I cant get this formula to work in a chart expression, I've tried with aggr and putting the expression in a variable, not sure if possible or what am I doing wrong

=count(if(FCT<Fractile(FCT,0.9),PO))

1 Solution

Accepted Solutions
mov
Champion III
Champion III

This works:

count(if(FCT < aggr(NODISTINCT Fractile(total<Wk_Num> FCT, 0.9),Wk_Num), PO))

See attached.  You'll probably need to replace the Wk_Num with the current field of the cycle group.

Edit: In fact, it works without total as well:

count(if(FCT < aggr(NODISTINCT Fractile(FCT,0.9),Wk_Num), PO))

The secret word is still NODISTINCT

View solution in original post

24 Replies
mov
Champion III
Champion III

You maybe need aggr(), but what you need for sure is "total".  Try this first:

=count(if(FCT<Fractile(total FCT,0.9),PO))

ashwanin
Specialist
Specialist

use

=count({<FCT<Fractile (FCT,0.9) >} PO)

oscarmqz
Creator III
Creator III
Author

Hi Michael, unfortunately that way it won't consider my dimension field, which is the month in the x axis.

If I add it to the Total clause, it won't work again

oscarmqz
Creator III
Creator III
Author

Hi Ashwani, I got an this: "error in set modifier expression"

mov
Champion III
Champion III

Can you upload a small example?

bhagirath
Creator III
Creator III

try this


=count({<FCT={'$(<Fractile (FCT,0.9))'} >} PO)

bhagirath
Creator III
Creator III

or

=count({<FCT={'<$(Fractile (FCT,0.9))'} >} PO)

sunny_talwar

May be this:

=Count({<FCT = {'< $(=Fractile(FCT, 0.9))'}>}PO)

Best,

Sunny

oscarmqz
Creator III
Creator III
Author

Not working