topic Re: Colors as Flags.... in QlikView

Colors as Flags....

leocattqv — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Colors as Flags....

vishsaggi — Fri, 18 May 2018 21:45:08 GMT

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?

Re: Colors as Flags....

shiveshsingh — Sat, 19 May 2018 04:15:32 GMT

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

Re: Colors as Flags....

isingh30 — Sat, 19 May 2018 12:44:01 GMT

Please check the attachment. Let me know.

Thanks

Re: Colors as Flags....

leocattqv — Tue, 22 May 2018 17:36:11 GMT

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.

Re: Colors as Flags....

leocattqv — Tue, 22 May 2018 17:39:27 GMT

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.

Re: Colors as Flags....

isingh30 — Tue, 22 May 2018 18:10:46 GMT

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

Thanks.

Re: Colors as Flags....

leocattqv — Tue, 22 May 2018 18:45:55 GMT

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.

Re: Colors as Flags....

vishsaggi — Tue, 22 May 2018 19:37:00 GMT

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

Re: Colors as Flags....

leocattqv — Tue, 22 May 2018 20:05:11 GMT

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

Re: Colors as Flags....

vishsaggi — Tue, 22 May 2018 20:14:21 GMT

This is what i see in your attached file? Can you point out where the issue is?

Re: Colors as Flags....

leocattqv — Tue, 22 May 2018 20:40:38 GMT

I am clearly not communicating what I want - my apologies.

I was hesitant to send out the original file because of its size, but a partial load should do the trick.

In the Product Brand tab, you will see the DJO Surgical Box green.

when you click on djo Surgical, and go to product family, again, they are all green.

When you go to part number, you will see a few of them red. this is because those parts are out of control. therefore the product brand and families those parts are in should be marked red.

at the end of the day, I am trying to build an alert system to show that if a part goes out of control, those families and Product brands should also be out of control (Red).

I have attached the file that I am working with, please let me know if this doesnt makes sense.