Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

coloring of total depending on subtotal

Hi Folks,

i got a Question, my data-structure does look like:

 

ProjectValue
A100
B80
  
Subproject 
A180
A220
B150
B230

 

my Question is: as you see my Subtotal of subprojectA2 is 20 and Project A is 100

how can i make the following Color Expression: if my Subtotal of Subproject is 20, so then Total of my Project should be red ?

 

does anybody have any idea?

Thanks a lot 

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

You want something like this?

image.png

View solution in original post

12 Replies
lironbaram
Partner
Partner

hi

you can try something like 

if (min(aggr(sum(Value),subproject,Project))<20,red())

beck_bakytbek
Master
Master

Hi Liron,

thanks a lot for your time and help,

what if, if my value within table are percent value like 20 %, i tried to impelement your solution, but it does not work,  am i missing something?

sunny_talwar

Would you be able to share a sample where we can see this laid out in a chart?

beck_bakytbek
Master
Master

Hi Sunny 

 

of Course , thanks a lot

 

 

sunny_talwar

In this example... I see one cell is highlighted (20%)... which might be the sub-project... how do I know what is the project it is associated with?

beck_bakytbek
Master
Master

Hi Sunny,

 

my Color Expression is false, i tried to make the Color Expression: if my Kriterien is under 40 %, then my total: Teilprozesse, Use Case should be red

sunny_talwar

What do you mean? Not sure I understand

beck_bakytbek
Master
Master

i mean:

 

if my Dim: Kriterien under 40 % , then my TotalDim: Teilprozesse and Use Case should be red

sunny_talwar

Isn't it doing that already?

image.png