topic Re: Cyclic group selection in QlikView

Cyclic group selection

Mon, 09 Dec 2013 16:14:57 GMT

We have a cycle group which consists of Day, week, month, quarter, and year called g_DateSelection. This is setup as a dimension in a chart and working fine. I would like to be able to use the selection of that cyclic group in a variable expression to perform another calculation. For example, if on the chart, the user has selected the cyclic group and change it to display Week, can I write an expression outside this chart that will tell me that week versus day, month, etc is selected? I tried GetCurrentFiled(g_DateSelection) but that doesn't work. Any ideas?

Re: Cyclic group selection

jerem1234 — Mon, 09 Dec 2013 16:38:42 GMT

GetCurrentField(g_DateSelection) should work. Make sure you do not put single quotes around it. Just g_DateSelection (not 'g_DateSelection'). I think double quotes will work, "g_DateSelection", also. Try testing it out in a textbox and see what returns.

Hope this helps!

Re: Cyclic group selection

Mon, 09 Dec 2013 18:27:52 GMT

I was able to use the first suggestion to get the selection of the cyclic group and then I used that to write an expression based on what is currently selected from the cyclic group. Thanks!

Re: Cyclic group selection

Thu, 08 May 2014 18:49:25 GMT

How did you get the current selection of the field selected in the cyclic group?