Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

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.

helen_pip
Contributor II

Set analysis in a graph

Hello

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

Thanks

Helen

1 Reply
MVP
MVP

Re: Set analysis in a graph

Helen,

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.