topic Fractile and Set Analysis - Date range in QlikView

Fractile and Set Analysis - Date range

stevegimbrollmt — Tue, 02 Aug 2011 12:54:25 GMT

Hi guys

Is it possible to do this set anaylsis in a fractile

e.g. =fractile(IF(KPI_CHT='GGR', CHT_VALUE),.8)

and I want to add a 30day bracket in it like this

{<[kpi_date]={">=$(=date((created_date)-30))<=$(=date((created_date)))"} }

thanks a lot!

Steve

klausskalts — Tue, 02 Aug 2011 13:25:16 GMT

My guess is that this might work:

[kpi_date]={">=$(=max(date((created_date))-30)),<=$(=max(date((created_date))))"}

But remember that you will still have to face some issues regarding re-use of fields in dimensions etc .....

stevegimbrollmt — Tue, 02 Aug 2011 13:44:32 GMT

thanks for your reply, but how does this effect the fractile function?

I am using this in a graph for a percentage line.

I want the fractile to change also based on date range, is that possible?

danielrozental — Tue, 02 Aug 2011 14:42:21 GMT

Steve, why don't you try posting a sample application so we can help you.

Something like this should work

fractile(

[kpi_date]={">=$(=max(date((created_date))-30)),<=$(=max(date((created_date))))"},

KPI_CHT={'GGR'}

>} CHT_VALUE, 0.8)

stevegimbrollmt — Tue, 23 Aug 2011 11:47:18 GMT

Hi guys, just to let you know that this was solved by doing something like this

=fractile({$<KPI_CHT={'GGR'}, RUNDATE_CHT={'>=$(=v_30_Days)<=$(=RUNDATE_DTL)'}>}CHT_VALUE, .8)

thanks a lot for your help guys