topic Pivot Table & cyclic expression in QlikView

Pivot Table & cyclic expression

Thu, 06 Jan 2011 19:06:48 GMT

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

Pivot Table & cyclic expression

pover — Thu, 06 Jan 2011 22:58:49 GMT

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.

Pivot Table & cyclic expression

Fri, 07 Jan 2011 21:29:30 GMT

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

Pivot Table & cyclic expression

pover — Sat, 08 Jan 2011 01:04:37 GMT

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.

Re: Pivot Table & cyclic expression

AnthonyBuck — Wed, 17 Apr 2019 09:29:30 GMT

A blank expression, brilliant! I also labelled the expression with a space so it doesn't display the =' '

Excellent solution to my problem, there are lots of Cyclic buttons on the pivot table, but it works a treat!

Removing the cell borders, playing with alignment and column widths have made my interactive pivot table work perfectly.

Thank you.