topic Re: How to format a Dimension color on a Table in QlikView

How to format a Dimension color on a Table

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I'm quite new beginner in QlikView as an enduser.

I've added a new Dimension (NormTime) on the table below and I would like to apply the format color as the other columns. Could you please help ? Thanks.

QlikView version :

Best Regards,

Kanda

Re: How to format a Dimension color on a Table

Fri, 02 Sep 2016 14:50:58 GMT

On the "Style" tab, select "Stripes every 1 row"

Re: How to format a Dimension color on a Table

stigchel — Fri, 02 Sep 2016 14:53:43 GMT

There's probably a background color expression for the other dimensions? Click on the + Sign of one of the colored dimensions, copy the expression for the background color and paste it in the background color expression of the newly added dimension.

Re: How to format a Dimension color on a Table

Anil_Babu_Samineni — Fri, 02 Sep 2016 15:03:46 GMT

If you are using qv12, then must be lot of features are there. As piet, expansion that is very useful for you. So, you need to add expression like nested if, then you will get particular cell back ground.

Re: How to format a Dimension color on a Table

ecolomer — Fri, 02 Sep 2016 15:07:03 GMT

see thisdoc

Re: How to format a Dimension color on a Table

rupamjyotidas — Fri, 02 Sep 2016 15:26:25 GMT

Custom Format Cell would help you .

Advanced Table Formatting in QlikView « BI Commons

Re: How to format a Dimension color on a Table

Fri, 04 Nov 2016 09:11:08 GMT

Hi All,

Thanks a lot for your feeback. This issue has been solved by our QlikView consultant. The feedbac from Enrique seems to be the solution.

Regards,

Re: How to format a Dimension color on a Table

Fri, 04 Nov 2016 09:11:45 GMT

Thanks 🙂

Re: How to format a Dimension color on a Table

ecolomer — Fri, 04 Nov 2016 17:19:21 GMT

you're welcome.

Saludos,

Enrique