Colors as Flags....

[leocattqv]

Hi Community - I have another question.

I have three levels of Tables

I will call them Top Level, Mid level and Bottom Level.

All of these parts are either Red Or Green depending on their value.

I have a requirement that if Any value on the bottom level shows red then the midlevel needs to show red.

if any Midlevel value is red then Top level needs to show Red.

I Believe (someone may have an idea in another direction)  I need a flag based on Green or Red.

Has anyone dealt with this before? is there any direction someone can point me?

I would appreciate it.

thanks

-L

[vishsaggi]

Can you share some sample data for your Top Mid and Bottom levels and your expected output you want to see?  I mean where you want to use these flags in UI?

[shiveshsingh]

You can add it in UI through Visual Cues tab, if i got you correct

[isingh30]

Please check the attachment. Let me know.

Thanks

[leocattqv]

HI Vishwarath,

I have created some sample data - you will notice that Part and Product 1 has 1 red and 1 Green, Part and Product 2 has 2 red and one green.

I am looking for the brand to be red Because there are Red in each of them even though combined they may have a total of Green.

I hope this makes sense.

[leocattqv]

Hi Ishdeep,

I know I can use the visual cues for a level.  what I am looking for is the red/green for all based on the Part Level.  I have attached the sample data.  I hope it makes sense.

[isingh30]

Can you provide your sample input & output? To get an idea of your desired result.

Thanks.

[leocattqv]

I have modified the sheet with the desired output.  you will notice that Brand 1 is green because there are no red flags in Part or Product

Brand 2 is red because 2 out of the 3 are red.

[vishsaggi]

What is your expected output based on the attached qvw file?

[leocattqv]

Hi Vishwarath

I would expect  Brand 1 to be green because there are no red in Part or Product of Brand 1

Brand 2 is red because 2 out of the 3 are red.

To be clear the Brand boxes should be red for Brand 1 and Green for Brand 2

Let me know if I am not making sense