Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
matthi0uw
Partner - Contributor II
Partner - Contributor II

KPI - coloration by measure field name

Hi,

In KPI, there is 2 measures and conditional coloration :

 kpi_2measures.JPGkpi_2measures_color.JPG

This exemple displays :

  • measure1  = sum(dim1)
  • measure2 = sum(dim2)

If I change the formula (measure1 = sum(dim3), I have to change 2 fields.

Is it possible to set condition by name of field ({measure1} or something like that) instead of name of dimension (dim1) or expression sum(dim1) to avoid missing change ?

Matthieu

Labels (1)
  • Chart

2 Replies
Anil_Babu_Samineni

Please create those measures in Master Item and apply the (Hex) code for that. That deserved the same.

If you want to limit data level, My suggestion to go like yours with conditions instead static.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
matthi0uw
Partner - Contributor II
Partner - Contributor II
Author

Your idea need a master item for each kpi if I understand correctly and I already use dynamic conditions.

I will try to explain another time with steps and example:

  1. Create my KPI
  2. Add 1st number : sum({ $<id_periode=2019>}[sales])
  3. Add 2nd number :  sum({ $<id_periode=2018>}[sales])
  4. Add % as label of 2nd number : Num( sum({ $<id_periode=2019>}[sales]) / sum({ $<id_periode=2018>}[sales]) ) - 1 , '0,00%')
  5. Add color and symbol :  
    1. value < threshold1 = symbol 'arrow down' + 'orange'
    2. threshold1 < value < threshold2 = symbol 'arrow right' + 'light blue'
    3. threshold1 < threshold2 < value = symbol 'arrow up' + 'dark blue'.

with:

  • threshold1 = sum({ $<id_periode=2018>}[sales])
  • threshold2 = sum({ $<id_periode=2018>}[sales])+1

When I change something, I have to change 1st number, 2nd, % and colors. Is it possible to say something like : threshold1 = {1st-number} ?