topic Custom Editing in Pivot table in QlikView

Custom Editing in Pivot table

Tue, 23 Aug 2011 13:34:04 GMT

I have a pivot table with 5 expressions and one dimension. The dimension sorts the expressions into 12 categories. I want to highlight one out of the 12 rows, but in the custom edit I can only seem to highlight all of the dimension fields. Is there an alternative to how to go about this?

Thanks,

Craig

Custom Editing in Pivot table

its_anandrjs — Tue, 23 Aug 2011 13:41:07 GMT

Hi,

Do you have any sample file it goes very easy.

Regards,

Anand

Custom Editing in Pivot table

Tue, 23 Aug 2011 13:54:23 GMT

I'll put something together real quick.

Custom Editing in Pivot table

Tue, 23 Aug 2011 14:02:34 GMT

This is a real small sample I threw together.

Now say I want to Highlight in grey just row 8.

Re: Custom Editing in Pivot table

sridhar240784 — Tue, 23 Aug 2011 14:02:46 GMT

Hi,

Are you looking for something like attached one.

if so, you can do it with the backgroud color of the expression and dimension. This you can find when you expand the + symbol of expression and dimension.

Have a look at the attached application.

If this is not helping you, pl post sample application with you requirement.

-Sridhar

Custom Editing in Pivot table

Tue, 23 Aug 2011 14:08:45 GMT

Thanks a lot!

I'm still trying to get the hang of this!