topic Re: Dynamic color based Current Status ?? in QlikView

Dynamic color based Current Status ??

chaper — Tue, 23 Feb 2016 21:01:10 GMT

Need help

I am trying create field/expression to get overall Status Color for item based on Stage. If any stage has black color get color from previous stage as Overall color for that item.So For C Overall status color should be Amber as Stage Status for 3&4 are Black and For item B Overall Status color should be Green as Stage Status is Black fro Stage 4 is black.

Re: Dynamic color based Current Status ??

Gysbert_Wassenaar — Wed, 24 Feb 2016 16:34:55 GMT

See attached example.

Re: Dynamic color based Current Status ??

sunny_talwar — Wed, 24 Feb 2016 16:37:52 GMT

Didn't know RGB worked in the script to create a color field. Thanks for this Gysbert

Re: Dynamic color based Current Status ??

Gysbert_Wassenaar — Wed, 24 Feb 2016 16:46:52 GMT

RGB() is just a 'convenience' function to create a big number. A number that happens to be something that can be used to tell the software to render something in a certain color.

Re: Dynamic color based Current Status ??

chaper — Wed, 24 Feb 2016 17:07:49 GMT

Thanks for reply Gysbert. Your background color expression works great if I want to show stage color of previous stage if it current stage is black .But I am looking for something like below.Overall Stage Status color should be latest Stage Color if it not black.For example item A has yellow for last stage 4 so overall Color for Stage should be yellow .For item B Stage 4 is black so go to previous Stage which is 3 and its color is green so overall color of stage should be Green.

thanks for your help

Re: Dynamic color based Current Status ??

Gysbert_Wassenaar — Wed, 24 Feb 2016 17:12:37 GMT

Even easier. Remove the if statement and the last branch:

FirstSortedValue({<[Stage Status]-={'Black'}>}total <Item> Color, -Stage)

Re: Dynamic color based Current Status ??

chaper — Wed, 24 Feb 2016 17:15:04 GMT

I was about to reply that it worked if I remove If condition. .And you go it right .Many thanks Gysbert.

Re: Dynamic color based Current Status ??

chaper — Wed, 24 Feb 2016 18:21:15 GMT

Hey Gysbert.Will it work only on expression not on dimensions?When I applied same logic to large data set it is not working .It does not work with FirstSortedValue({<[Stage Status]-={'Black'}>}total <Item> Color, -Stage) but it works with if([Stage Status]='Black',FirstSortedValue({<[Stage Status]-={'Black'}>}total <Item> Color, -Stage),Color) but the other way like below