# 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
Did you mean:  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  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 24 Replies  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))  Specialist

use

=count({<FCT<Fractile (FCT,0.9) >} PO)  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  Creator III
Author

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

Can you upload a small example?  Creator III

try this

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

or

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

May be this:

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

Best,

Sunny  Creator III
Author

Not working  Community Browser