topic Set Analysis Modifier Issue in QlikView

Set Analysis Modifier Issue

raju_salmon — Wed, 12 Aug 2015 10:47:45 GMT

Hi,

Though i have gone through the set analysis material, for below case i cannot able to write the expression.

By defaults, sales should be display for latest year

Sum({$<Year={$(vMaxYear)}>}Sales)

Whereas if i select any other year, then filtering should be done.

Any suggestions please.

MK_QSL — Wed, 12 Aug 2015 10:49:15 GMT

Hope you have defined your variable as below

vMaxYear

Max(Year)

i.e. without = sign in Variable Overview

swuehl — Wed, 12 Aug 2015 10:49:32 GMT

Please post your definition of vMaxYear.

You can also try

=Sum({<Year = {$(=max(Year))}>} Sales)

raju_salmon — Wed, 12 Aug 2015 10:51:29 GMT

I have created variable

LET vMaxYear =Year(Today();

sunny_talwar — Wed, 12 Aug 2015 10:51:43 GMT

Try this:

=Sum({$<Year={"$(=Max(Year))"}>}Sales)

MK_QSL — Wed, 12 Aug 2015 10:52:22 GMT

Remove This vMaxYear from script

Go to variable overview

create variable as

Name

vMaxYear

Max(Year)