topic New Array: For Fractile Function in QlikView

New Array: For Fractile Function

Mon, 25 Jul 2011 10:09:06 GMT

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

New Array: For Fractile Function

danielrozental — Mon, 25 Jul 2011 14:06:10 GMT

Byron,

You can try something like this

FRACTILE(aggr(AnnualFixedCTC,OCCUPATION),0.25)

Beware that it will probably not have amazing performance.

New Array: For Fractile Function

Mon, 25 Jul 2011 14:21:28 GMT

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