Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Pivot Table & cyclic expression

Hi

I don't understand why in a pivot table I can't swap between different expression grouped as in straight table.

What is the best solution to solve this issue ?

Regards

JJ

Tags (1)
3 Replies
pover
Honored Contributor

Pivot Table & cyclic expression

I assume your pivot table is a crosstable and that the expression group is the only expression so you don't see the cycle icon because the expression label is automatically suppressed, right?

If that's the case then you would think there would be an option to undo the automatic suppression, but the only solution seems to be to add an additional empty expression so that the expression label and cycle icon appear.

Regards.

Not applicable

Pivot Table & cyclic expression

Thanks Karl, very tricky

I got this :

Do you think it's possible to hide the "blank" column ? My expression is =' '

Thanks for your help

JJ

pover
Honored Contributor

Pivot Table & cyclic expression

Mmm.. you can't seem to hide it but you can eliminate the border by either going to presentation tab and disabling the Vertical Expression Cell Borders option, or by using the Custom Cell Format Tool to remove the border on one side.

Regards.