Set Anlysis

[#1]

I want to show the sale on the max year

So what will be the set analysis expression??

[jyothish8807]

Hi Amit,

Simlpy replace Sales with Salesunit in the expression i suggested or try the expression suggested by Carly McClintock.That should work.

Regards

KC

[#3]

Hi,

you can try

Sum({$<Year = {$(=Max(Year))}>} [Sale Unit]).

You can try this too

make  a variable 'var1' and assign

=max(Year)

and try this

Sum({$<Year = {$(var1)}>} [Sale Unit]).

By this method you can check the value of varaible and see if the qlikview is calculating it correctly.(for troubleshooting purpose.

with regards

Harshita gaur

[#4]

check the Year field data and have a look at the format, most of the suggestions already should work, option why not is maybe that field

[#5]

its working now guys

[jyothish8807]

If its working, then please close the thread.

Regards

KC

[#7]

can you explain me what it will do ?  {<Year_Filed={'$(=Max(Year_Field)'}>}