Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Contributor II

Set analysis in a graph


I have the following set analysis which works O.K in a Text box, and the result return 02:03



Time(RangeFractile(.5, $(=Concat([Total Wait], ',') & ',' & Concat(CONCLUSION_WAIT_MINS, ','))

I want to use this set anlysis as an expression in a graph.  My dimension to plot against this againist is called Main_Week.  However the graph currently shows 02:03 for every week.

Could someone kindly help me write the correct syntax so the graph changes for every week



1 Reply

Re: Set analysis in a graph


the dollar sign expansion is evaluated once per chart, in global context, so won't take your dimension values into account.

If you could create a single common field from [Total Wait] and [CONCLUSION_WAIT_MINS], you could use fractile() function without a dollar sign expansion, instead of the current solution.