Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Visual Cue

I'm trying to setup an expression for a visual cue.  I'm comparing Sales $ to Budget $.  The expression for Budget $ is GetSelectedCount(Month)*(sum([Budget $])/12) .  I use the same expression for the Sales $ visual cue for both upper and lower limit.  All my dimension values are red.  If I select a specific dimension, the expression is applied correctly. It appears that when no dimension is selected it is comparing against the total.  Any ideas?  Thanks.

2 Replies

GetSelectedCount(Month) will be zero if no month value is selected. You can try count(distinct Month) instead.

talk is cheap, supply exceeds demand
Not applicable

This did not provide the desired results.  If I select on the product group dimension I get the desired result (text turns green).  With only the months selected the text remains red even though sales is greater than budget.  It appears the visual cue is not being process for the row amount but instead the whole table.