topic 2 visual cues in one dimension within pivot table in QlikView

2 visual cues in one dimension within pivot table

francisvandergr — Wed, 24 Jun 2015 17:44:29 GMT

I have a dashboard with the values O and the Value L. For those values i have 2 visual cues:

see attached example:

='AVG O in relation to total orders ' & count({1<Status = {O}>}[offerte Nr.]) / Count( {1} Total [offerte Nr.] ) & '

if AVG from Status O in table > then formula above, Green else Red'

='AVG L in relation to total orders ' & count({1<Status = {L}>}[offerte Nr.]) / Count( {1} Total [offerte Nr.] ) & '

if AVG from Status L in table < then formula above, Green else Red'

sunny_talwar — Wed, 24 Jun 2015 17:47:44 GMT

Sorry but I don't know what you question is? Is something not working as expected?

francisvandergr — Wed, 24 Jun 2015 17:58:43 GMT

If avg of status O is above 39,8% i wanna have green below this value it must be red

If avg of status L is below 26,55% i wanna have green above this value it must be red

39,8 comes from : count ({1<Status = {O}>}[offerte Nr.]) / Count( {1} Total [offerte Nr.] )

26,55 comes from : count({1<Status = {L}>}[offerte Nr.]) / Count( {1} Total [offerte Nr.] )

sunny_talwar — Wed, 24 Jun 2015 18:13:44 GMT

Is this what you are looking for?

Instead of using visual cues, try using Text Color:

francisvandergr — Wed, 24 Jun 2015 18:43:57 GMT

Yes! indeed do you have for me the QVW so i can see what you have done in the text colour formula ?

sunny_talwar — Wed, 24 Jun 2015 18:45:11 GMT

It is attached with my post above.

francisvandergr — Mon, 29 Jun 2015 07:41:15 GMT

Hi sunindia,

Sorry but i downloaded the file and the formula is gone. You have the formula for me ?

Francis

sunny_talwar — Mon, 29 Jun 2015 10:28:50 GMT

Expression I used is:

If(Status = 'O', If(AVG < Count(TOTAL {1<Status = {'O'}>}[offerte Nr.])/Count( {1} Total [offerte Nr.]), RGB(0,127,0), RGB(255,0,0)),

If(Status = 'L', IF(AVG < Count(TOTAL {1<Status = {'L'}>}[offerte Nr.])/Count( {1} Total [offerte Nr.]), RGB(0,127,0), RGB(255,0,0))))

HTH

Best,

Sunny