topic Re: Set analysis with variable in QlikView

Set analysis with variable

Wed, 25 Nov 2020 16:16:04 GMT

Hello I have a problem with an expression where I am trying to use set analysis for age

Here is my expression:

Count({$<Age = {"8"}>})$(Age)

with age being:

Age =Age(AttendanceDate1,BirthDate1)

Can anyone help me figure it out and quick answers would be much appreciated

Re: Set analysis with variable

cliff_clayman — Wed, 29 Jun 2016 15:42:17 GMT

Try changing {"8"} to just {8}

Re: Set analysis with variable

Wed, 29 Jun 2016 15:46:53 GMT

Hey Cliff I started off like that that is why I added the "" maybe if I tell you that I had a red line underneath the set analysis as shown

Re: Set analysis with variable

cliff_clayman — Wed, 29 Jun 2016 16:06:43 GMT

What exactly is the problem? If it is a syntax issue, try:

Count({<[Age] = {"8"}>}[Age]) or Count({$<[Age] = {"8"}>}$([Age]))

Re: Set analysis with variable

sunny_talwar — Wed, 29 Jun 2016 16:25:57 GMT

May be this:

Count({$<AgeIDField= {"=Age(AttendanceDate1,BirthDate1) = 8"}>}) AgeIDField)

Replace AgeIDField with whatever your trying to find the age of.

Re: Set analysis with variable

Wed, 29 Jun 2016 16:40:15 GMT

Hello Sunny sorry for the confusion but I want to just show the values for the Age 8 that is why I was using the variable I am not trying to work out the age as I have already got them I just want to limit it

Re: Set analysis with variable

sunny_talwar — Wed, 29 Jun 2016 17:07:04 GMT

Is Age field getting calculated in the script?