topic Re: Variable in Set Analysis in QlikView

Variable in Set Analysis

Mon, 22 Jun 2015 14:56:18 GMT

Hi everybody,

I'm having some issues with the syntax of a set analysis. here is my formula:

=MaxString({$<Position={"=1+$(=vContact)*5"}>} [Contact Name])

I'd like to retrieve the contact name if the position equals (1+MyVariable*5). Any suggestions?

thanks in advance!

Re: Variable in Set Analysis

sunny_talwar — Mon, 22 Jun 2015 14:58:47 GMT

Give this a try:

=MaxString({$<Position={"=$(=1+$(=vContact)*5)"}>} [Contact Name]) or

=MaxString({$<Position={"=$(=1+$(vContact)*5)"}>} [Contact Name])

Re: Variable in Set Analysis

Mon, 22 Jun 2015 15:02:01 GMT

Hi Sunindia,

I tried both but they didn't work 😞

Re: Variable in Set Analysis

sunny_talwar — Mon, 22 Jun 2015 15:05:05 GMT

What do you get when you put this in a text box object?

=1+$(=vContact)*5

Does it give you a position you would like the contact name for?

Re: Variable in Set Analysis

swuehl — Mon, 22 Jun 2015 15:05:46 GMT

=MaxString({$<Position={$(=1+vContact*5)}>} [Contact Name])

assuming that =1+vContact*5 returns the correct position in a text box.

Re: Variable in Set Analysis

Anonymous — Mon, 22 Jun 2015 15:09:41 GMT

David

Have a look at this currently active thread,Quick set analysis question

In it hic states "

"The dollar expansion and the Set Analysis selection is made before the chart is calculated.

Set Analysis is never evaluated for each row. You can only use expressions that can result in selections before the chart is evaluated."

This could well be your issue, but hard to tell without more info like what is variable vContact set to ?

Re: Variable in Set Analysis

ramoncova06 — Mon, 22 Jun 2015 15:09:59 GMT

what happens when you expand the variable ?

=MaxString({$<Position={"$(=1+$(vContact)*5)"}>} [Contact Name])

Re: Variable in Set Analysis

Mon, 22 Jun 2015 15:16:46 GMT

thanks, the second formula worked! For some reason I had to created another variable as my original would go blank for some reason. The new one keeps the value and now it's fixed. thanks again for your help, guys!

Re: Variable in Set Analysis

sunny_talwar — Mon, 22 Jun 2015 15:18:03 GMT

Not a problem

I am glad we were all able to contribute.

Best,

Sunny