topic Re: Visual Cue in QlikView

Visual Cue

Fri, 20 Feb 2015 21:46:24 GMT

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.

Re: Visual Cue

Gysbert_Wassenaar — Sat, 21 Feb 2015 11:18:31 GMT

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

Re: Visual Cue

Mon, 23 Feb 2015 15:06:15 GMT

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.