12 Replies Latest reply: Mar 17, 2017 5:09 AM by Riccardo Centomo Branched from an earlier discussion.

Qlik sense straight table measure color expression

PAOLO MAPELLI Feb 5, 2015 9:21 AM

Hi,

talking about expressions, how can I refer the measure (column) itself into a color expression ?

In the above example, if "Sales" is a measure (let's say, "sum(sales_value)") what is the color expression used to alter background color ? Probably, "if(sum(sales_value)>100000,green(),white())". But if it is a more complex measure, could be possible refer itself with something like: "if([my_self]>100000,green(),white())" ?

I'm using Qlik Sense 1.0.2

Thanks.

Re: Qlik sense straight table dimension color expression

Michael Tarallo Feb 5, 2015 9:20 AM (in response to PAOLO MAPELLI)

Hello Paolo - I created a new thread for your discussion.

Check this out Color by Expression

Let me know if this is what you need:

Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,
Mike Tarallo
Qlik
Like Show 0 Likes (0)

Actions
- Re: Qlik sense straight table dimension color expression
  
  PAOLO MAPELLI Feb 5, 2015 10:30 AM (in response to Michael Tarallo )
  
  Hi Michael,
  not exactly. In your example you have "if(Sum([Sales Margin Amount])/...". In my case I've a "pre-defined" and complex measure as column in my table (named "DoD pct."). I'd like to write my color expression with something like "if([DoD pct.]/...", in other words a way to refer the column I'm writing in the color expression, by absolute (column/measure name) or relative (e.g. "myself","this") id.
  
  Like Show 1 Like (1)
  
  Actions
  - Re: Qlik sense straight table dimension color expression
    
    Michael Tarallo Feb 5, 2015 10:32 AM (in response to PAOLO MAPELLI)
    
    Hi Paolo - that will work - only if this complex expression is created in the load script as part of the data mode and not as a Measure in the list of Master Items.
    
    Is that clear? Let me know if you need an example.
    
    Mike
    
    Like Show 2 Likes (2)
    
    Actions
    - Re: Qlik sense straight table dimension color expression
      
      PAOLO MAPELLI Feb 5, 2015 10:40 AM (in response to Michael Tarallo )
      
      It is a Master Item...
      
      Do you plan to add this feature in next Qlik Sense releases ?
      
      Thanks again.
      
      Paolo.
      
      Like Show 0 Likes (0)
      
      Actions
      - Re: Qlik sense straight table dimension color expression
        
        Michael Tarallo Feb 5, 2015 12:15 PM (in response to PAOLO MAPELLI)
        
        Hi Paolo,
        
        Yes it is on the roadmap to make various improvements such as this.
        
        If you can, please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.
        
        Regards,
        Mike Tarallo
        Qlik
        
        Like Show 2 Likes (2)
        
        Actions
        
        Re: Qlik sense straight table dimension color expression
        
        PAOLO MAPELLI Feb 5, 2015 12:30 PM (in response to Michael Tarallo )
        
        I'd like to mark the answers but I don't see how to do it, even I'm correctly logged in...
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: Qlik sense straight table measure color expression
        
        Michael Tarallo Feb 5, 2015 12:41 PM (in response to PAOLO MAPELLI)
        
        I fixed it - the new thread i opened was not marked as a question, I modified it. Sorry about that.
        
        Like Show 1 Like (1)
        
        Actions
        
        Re: Qlik sense straight table measure color expression
        
        PAOLO MAPELLI Feb 10, 2015 3:58 AM (in response to Michael Tarallo )
        
        Hi Michael, I'm hoping that, other than measures and master items, color expression feature will be also extended to dimensions.
        
        Regards,
        
        Paolo.
        
        Like Show 0 Likes (0)
        
        Actions
      - Re: Qlik sense straight table measure color expression
        
        Robert Hutchings Feb 5, 2015 12:26 PM (in response to PAOLO MAPELLI)
        
        Agree
        
        Hopefully this is planned for a future release
        
        Otherwise it defeats the purpose a bit of having pre-defined measures set up in this way
        
        BTW I thought Measure in the list of Master Items was a great idea. I wish they had this in QV. Variables is OK but is a bit limited
        
        These Measure in the list of Master Items should work exactly as if they had been set up in the script. Including in colour expressions.
        
        Including being able to further filter
        
        eg
        
        One measure could be included in another measure
        
        sum ({< Customer = {ABC}>} Mastermeasure)
        
        NB TBH I'm unsure if this can be done at present
        
        Like Show 2 Likes (2)
        
        Actions
        
        Re: Qlik sense straight table measure color expression
        
        PAOLO MAPELLI Feb 6, 2015 5:47 AM (in response to Robert Hutchings)
        
        I agree with that, Master Items nesting would be another interesting and useful feature.
        
        Ciao.
        
        Paolo.
        
        Like Show 0 Likes (0)
        
        Actions
    - Re: Qlik sense straight table measure color expression
      
      Karl Fredberg Jun 4, 2015 5:50 AM (in response to Michael Tarallo )
      
      It's possible to refer to itself with the column function. "If(Column(1)>10000,Green(),white())"
      
      Column() returns the value found in the column corresponding to ColumnNo in a straight table, disregarding dimensions. For example Column(2) returns the value of the second measure column.
      
      column(ColumnNo)
      
      Like Show 1 Like (1)
      
      Actions
  - Re: Qlik sense straight table measure color expression
    
    Riccardo Centomo Mar 17, 2017 5:09 AM (in response to PAOLO MAPELLI)
    
    In my Qlik Sense 3.1 SR4 actually is possible to build the color expression by refer the label name of the straight table, but actually the check expression in the bottom don't recognize the name of the label and give you an error..
    But the expression will work anyway..
    
    Like Show 0 Likes (0)
    
    Actions