Discussion Board for collaboration on QlikView Layout & Visualizations.
The report has one dimension brand and one expression Sum(Sales). Average of total sales should be displayed on the reprot as Total. And the background color of sales should be based on the following conditions.
The background colors for brands are according to the given conditions but not the Total row as below.
Please help me on this so that Total background color should be according to the given conditions.
Please find attached for the sample application.
Thanks Jagan for your reply.
Actually, for my requirement I have three set of conditions, which I feel cannot be placed in visual cues. Below are the conditions.
if(variance>90 or variance<-90,rgb(255,34,34),
if(variance>45 and variance<=90 or variance<-45 and variance>=-90,RGB(255,128,0),
if(variance<=45 or variance>=-45,Green())))
Is there a way to put these conditions in visual cues? If yes, please let me know that, if not please let me know for any work around.
I think there is no option for 3 conditions in Visual clues. You can give only two conditions <= and >= and default.
Instead you can by adding another chart below for displaying total. Check the attachment.
Users should be able to export the report to excel. If we use two reports, they cannot export both the reports at once. And we should not use any macro.
Go to expressions click on the plus sign and then Background expressions. Thats how we did on one of our project. The Visual Cues also puts the expression embedded there, use multiple if statements qith RGB to set the appropriate color.