topic Re: Cyclic group in pivot chart as conditional dimension in QlikView

Cyclic group in pivot chart as conditional dimension

carolin01 — Wed, 30 Apr 2014 11:58:22 GMT

I´m trying to use a cyclic group in a pivot table that has lot´s of fields all enabled as conditional dimensions. But if I now to the same with my cyclic group its not possible to change between the fields of the cyclic group.

Does anybody have any suggestions why it´s not working or how I can make it working?

Best regards

Carolin

Re: Cyclic group in pivot chart as conditional dimension

maxgro — Wed, 30 Apr 2014 19:25:19 GMT

see attachment

I suppose you have to use the group name (Time) in your expression Substring......, not the dimension (TransactionDate)

Re: Cyclic group in pivot chart as conditional dimension

Gysbert_Wassenaar — Thu, 01 May 2014 09:02:54 GMT

I don't think I understand what you're trying to do. Are you trying to create a dynamic cyclic group? That can't be done using the conditional expression for the cyclic group column.

Re: Cyclic group in pivot chart as conditional dimension

carolin01 — Thu, 08 May 2014 13:22:08 GMT

Yes, that is what I wanted to do: A cyclic group combined with a conditional expression so that it will only appear if you mark "TransactionDate" in the Listbox. At the same time it´s a pivot table. And it can´t be done, right? Hm, that would have been a nice option to do.