topic Re: Only Red Color Values sum - Table Box in QlikView

Only Red Color Values sum - Table Box

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

Hi All ,

Can you please help me. My Requirement is

This is table box .

In that table, In that A=A,B=B ,C=C... Displaying Green color .

Remaining things displaying the value >=5 Red Color , and remaining Blue color .

My problem is :- above screen shot total filed is there in that i want to displaying only the sum of Red color values.

Note*: I have used if condition, But code is number of line is there ,each line having 15 if condition (Possible combination).
Is there any way to solve the issue.

Thanks ,

Ram

Re: Only Red Color Values sum - Table Box

Frank_Hartmann — Tue, 31 Dec 2019 12:25:15 GMT

see attached qvw.

hope this helps

Re: Only Red Color Values sum - Table Box

Brett_Bleess — Tue, 31 Dec 2019 13:29:05 GMT

Frank seems to have given you full solution, so I just wanted to let you know to be sure to return to the thread and use the Accept as Solution button on Frank's post if his sample app gets you what you needed for your use case. This gives him credit for the help and lets the other Community Members know it worked. If you have further questions, leave an update post.

Regards,
Brett