Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

New Array: For Fractile Function

Hi All,

In my tables that i loaded, I had to use left join to get rid of loops. The result, a crosstable where the new fields from the tables that were joined have been defined. I've said this to set some context around what my data looks like.

Before the join i used FRACTILE(AnnualFixedCTC,0.25) to give me the 1st Quartile and it worked perfectly. With my new 'TABLE'  it is not giving me the correct value. This is because my range is now 'larger' due to duplicate 'values' because of the joins.

My question Is there anything I can do to limit/define my range for my fractile function. The fractile function dimension is OCCUPATION, encase you need that. I tried using my limited knowledge of aggr and set analysis with no such luck yet.

Thanks,
Byron

1 Solution

Accepted Solutions
danielrozental
Master II
Master II

Byron,

You can try something like this

FRACTILE(aggr(AnnualFixedCTC,OCCUPATION),0.25)

Beware that it will probably not have amazing performance.

View solution in original post

2 Replies
danielrozental
Master II
Master II

Byron,

You can try something like this

FRACTILE(aggr(AnnualFixedCTC,OCCUPATION),0.25)

Beware that it will probably not have amazing performance.

Not applicable
Author

Thanks Daniel. Looks so easy when shown the way All I had to change was occupation to employeeno, since the table already had occupation as a dimension. Thanks a lot Daniel


Cheers,

Byron