Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
carolin01
Luminary Alumni
Luminary Alumni

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

3 Replies
maxgro
MVP
MVP

see attachment

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

Gysbert_Wassenaar

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
Luminary Alumni
Luminary Alumni
Author

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.