topic Change Dimension Background in QlikView

Change Dimension Background

Thu, 16 Oct 2014 13:18:25 GMT

Hello Friends,

We have 3 fields Week, Date and Event (which is associated to a date).

Our requirement is crosstab having Dimension as Week which need to be highlighted when event is present (but date and event are not taken as dimensions).

Please find the attached screenshots for reference.

Week 1 and 3 should be highlighted with a color.

Thanks in Advance,

Siva Srinivas.

Re: Change Dimension Background

maternmi — Thu, 16 Oct 2014 13:27:42 GMT

Hi,

--> chart properties

--> expression

--> week properties, open by clicking on plus

-->background color

-->write the formula: if([event] <> 0, green(255))

hope that helps you!

Michael

Re: Change Dimension Background

vipin_mishra479 — Thu, 16 Oct 2014 13:41:04 GMT

Hi Siva,

Use This in Dimension

if(len(Event)=0,White(),Green())

Vipin

Re: Change Dimension Background

Thu, 16 Oct 2014 13:53:11 GMT

Thanks Michael and Vipin for your Quick responses.