topic Using a variable in a set expression in QlikView

Using a variable in a set expression

wnorwood — Thu, 16 Feb 2012 20:54:53 GMT

Hello,

I am new to QlikView and I am trying to do something I think should be easy, but I just can't seem to get it to work. I want to use a variable in my set expression. The variable (vslandYear) is set to the the value selected from a list box that uses a data island.

When I use the actual year number like below, the expression works just fine.

=sum({$<DateYear = {2008}>} Sales)

But, I want to it to work more like this:

=sum({$<DateYear = {$(vIslandYear)}>} Sales)

This results in all 0's in the results. Can anyone tell me what I am doing wrong?

Thanks!

Using a variable in a set expression

deepakk — Thu, 16 Feb 2012 22:00:41 GMT

hi,

I think you have not intialised the variable correctly.

the Variable should be defiend in either of the two ways.

vIslandYear = 2008

vIslandYear =max(DateYear )

I hope this resolves the issues

Deepak

Re: Using a variable in a set expression

CELAMBARASAN — Fri, 17 Feb 2012 02:36:38 GMT

Hi,

Use vIslandYear=Concat(Distinct DateYear,',');\\If you need to display with all the selected dates.

vIslandYear=Max(DateYear);\\To get the Maximum year from the selection.

Use expression as

=sum({$<DateYear = {$(=vIslandYear)}>} Sales)

Hope it helps

Celambarasan

Using a variable in a set expression

jagan — Fri, 17 Feb 2012 05:01:33 GMT

Hi,

Use this expression for Variable

=Concat(DISTINCT Year,',')

Use this expression

=sum({$<Year = {$(=vYear)}>} Amount)

Hope this helps you.

Regards,

Jagan.

Using a variable in a set expression

wnorwood — Mon, 20 Feb 2012 15:59:54 GMT

Thanks for all the help! Finally got it to work using the following:

=sum({$<DateYear = {$(=Only(IslandYear))}>} Sales)