topic Re: set issue in QlikView

set issue

QlikAngel — Wed, 02 Dec 2015 12:14:35 GMT

I have wrote the code of Previous Year in set it show previous year in set expression but data show of current year..

what will be the issue...

sum({<FYear=$(=Max(FYear-1)Amount)

Re: set issue

sunny_talwar — Wed, 02 Dec 2015 12:17:22 GMT

I am amazed that it is showing you anything because syntax is not right. Try this:

=Sum({<FYear = {'$(=Max(FYear)-1)'}>} Amount)

Re: set issue

QlikAngel — Wed, 02 Dec 2015 12:27:19 GMT

Nopes.. i have wrote so here got syntax mistake.. but i took in variable also it shows me previous year.. but data & total is coming of current year..

just let me know one thing.. is selected Year field will be in Variable field

in selection box i have field name called FYear

in Expression i am comparing with FYear = {'$(=Max(FYear)-1)'}>}

so is that correct.. in variable i m creating like Max(FYear)-1

Re: set issue

sunny_talwar — Wed, 02 Dec 2015 12:36:35 GMT

What is your chart dimension? Is it FYear by any chance?

Re: set issue

QlikAngel — Wed, 02 Dec 2015 12:40:51 GMT

i am selecting FYear on top .. my dimension is Customer Name

Re: set issue

sunny_talwar — Wed, 02 Dec 2015 13:07:42 GMT

So yes, you can create a variable vPreviousYear = '=Max(FYear) - 1' (Everything within the single quotes need to be in your variable)

and then use it like this:

=Sum({<FYear = {'$(vPreviousYear)-1)'}>} Amount)