Qlikview Selection

[ryanfoster84]

Hi,

i was wondering if someone could help i have the following piece of code

=If([Revenue Adjustment] = 0, 'Revenue Adjustments Not Included', 'Revenue Adjustments Included Up Through'& ' ' & Max([Year Month]))

so when the user select a month it will say if the adjustments have been loaded or not but i need to to say only the latest month which has been selected regardless of month selection can anyone assist. currently when you select a month it will say that month.

cheers,

ryan

[sunny_talwar]

What expression are you using for Revenue Adjustment? It is just Sum?

[ryanfoster84]

its a dimension that is summed in the extract script.

[sunny_talwar]

In one of the above posts, you added this screenshot:

You have year 2451 in your database or what is going on there?