topic Re: Background color Expression in QlikView

Background color Expression

nvijay5757 — Wed, 22 Dec 2021 17:19:50 GMT

Hi,

i need to display in pivot table

1. from blue_color to end_date (code = 'Y') ---> Blue color

2. from grey_color to end_date (code = 'N') -----> Grey color

3. if blue_color date is not available then consider as grey_color date

4. end_date ---> Green color

please help me i have tried but not reached.

like example

Re: Background color Expression

MarcoWedel — Wed, 22 Dec 2021 22:28:52 GMT

maybe something like:

=If(Only(WeekStart(Date_Range))=WeekStart(end_date), LightGreen(),
If(Only(WeekStart(Date_Range))>=WeekStart(Alt(blue_color,grey_color)) and code='Y', LightBlue(),
If(Only(WeekStart(Date_Range))>=WeekStart(grey_color) and code='N', LightGray())))

hope this helps

Marco

Re: Background color Expression

nvijay5757 — Fri, 24 Dec 2021 05:28:32 GMT

Hi Marco,

Thanks

the expression is working fine.

1. but in my case while applying some rows are not applying the color code. something is missing i have tried a lot can you please help me.

2. for my original qvw file this expression also not working, but test file is working, can i do any settings change.

Re: Background color Expression

markwood — Mon, 27 Dec 2021 12:07:12 GMT

Not working expression: Iif(sumSum([OrderDetailsTotal])> 1000,'green' ,'red')

Working expression (without formula): Iif(([OrderDetailsTotal])> 1000,'green' ,'red')

How to change color by conditional expression, when a formula is used?

Visit here : http://filesynced.net/

Re: Background color Expression

nvijay5757 — Tue, 04 Jan 2022 03:54:49 GMT

To display descending order of blue color and grey color like based on total number of days.