Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

carolin01
Contributor II

Cyclic group in pivot chart as conditional dimension


Hi

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.

Screenshot2.png

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

Best regards

Carolin

Tags (1)
3 Replies
MVP
MVP

Re: Cyclic group in pivot chart as conditional dimension

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

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.


talk is cheap, supply exceeds demand
carolin01
Contributor II

Re: Cyclic group in pivot chart as conditional dimension

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.

Community Browser