topic Re: What dos {$1} in the modifier do in Set Analysis in QlikView

What dos {$1} in the modifier do in Set Analysis

bwisealiahmad — Fri, 20 Jan 2017 11:29:50 GMT

This might be a really simple question, but I am hoping someone can point me in the way of some good documentation on this.

I've seen examples where {$1} is used in the moderator. What exactly does this mean?

Example could be

Sum({<Account = {$1}, Company = {$2}>}Sales)

Thanks.

Re: What dos {$1} in the modifier do in Set Analysis

girirajsinh — Fri, 20 Jan 2017 11:35:48 GMT

$1 – previous selection ($2: the second previous selection, etc.)

Re: What dos {$1} in the modifier do in Set Analysis

bwisealiahmad — Fri, 20 Jan 2017 11:44:31 GMT

So is it used to make the set analysis calculation more dynamic based on choices? What if I you haven't made a selection yet?

Re: What dos {$1} in the modifier do in Set Analysis

stabben23 — Fri, 20 Jan 2017 12:06:28 GMT

Maybe one off the most usless modifier ever?! or does someone have a great example to convince me.

Re: What dos {$1} in the modifier do in Set Analysis

eduardo_dimperio — Fri, 20 Jan 2017 12:07:31 GMT

Hey Ali, this material help me a lot with set analysis

I hope this could help you too.

Re: What dos {$1} in the modifier do in Set Analysis

girirajsinh — Fri, 20 Jan 2017 12:07:47 GMT

It is not being used in set analysis as you showed.

But like Sum({$1}Sales) , Sum({$1}Sales)

In situation where you want to see what difference it makes in tables or bars based on your selections.

You may creates set of bar charts showing different states. So its kind of dynamic comparisions

Re: What dos {$1} in the modifier do in Set Analysis

sunny_talwar — Fri, 20 Jan 2017 12:13:11 GMT

I think this is used in a variable if I am not wrong? See this:

Variables with Parameters

Re: What dos {$1} in the modifier do in Set Analysis

mayankraoka — Fri, 20 Jan 2017 12:14:11 GMT

Hi Ali,

PFA document for basic set analysis.

Regards,

Mayank

Re: What dos {$1} in the modifier do in Set Analysis

girirajsinh — Fri, 20 Jan 2017 12:38:46 GMT

Yes Sunny but I think in variable parameter is used with $1 , here Ali asked about {$1}

But good that your brought this up. It helps clearing both concept.

For Ali,

Lets say you define variable vTemp with expression Sum(Sales)/$1

then using $(vTemp(1000)) would mean Sum(Sales)/1000.

Sunny, pls correct me if I am mistaking here something in understanding them

Re: What dos {$1} in the modifier do in Set Analysis

sunny_talwar — Fri, 20 Jan 2017 12:41:34 GMT

Where are you seeing {$1}?

Sum({<Account = {$1}, Company = {$2}>}Sales) -> Looks more like variable with parameters

Sum({$1<Account = {'123'}, Company = {'xyz'}>}Sales) -> Now looks like it is referring to previous selection.....

Sample to follow

Re: What dos {$1} in the modifier do in Set Analysis

MK_QSL — Fri, 20 Jan 2017 12:44:04 GMT

I never came across like this...

Account = {$1}

Re: What dos {$1} in the modifier do in Set Analysis

sunny_talwar — Fri, 20 Jan 2017 12:45:19 GMT

Here you go....

Re: What dos {$1} in the modifier do in Set Analysis

bwisealiahmad — Fri, 20 Jan 2017 12:46:43 GMT

Correct. First example. So it's called variables with parameters?

Re: What dos {$1} in the modifier do in Set Analysis

sunny_talwar — Fri, 20 Jan 2017 12:48:05 GMT

I believe so... look at the attached sample....

Re: What dos {$1} in the modifier do in Set Analysis

MK_QSL — Fri, 20 Jan 2017 12:50:05 GMT

Got it...!!!

Very true..

Re: What dos {$1} in the modifier do in Set Analysis

petter — Fri, 20 Jan 2017 12:59:21 GMT

$1 can have two different meaning depending on where it is:

1) As a parameter inside a $-sign variable var1='$1*$2' and $(=var1(3,27)) will return 3*27 or 108

Here it is a parameter number $1 is parameter 1 from the caller $-sign expansion

2) As meaning previous selection as noted from others. Then it is called a SET IDENTIFIER a sibling of $ and $2, $3 ....

The way you posed the question Ali as {1} it means the first.

Re: What dos {$1} in the modifier do in Set Analysis

Anil_Babu_Samineni — Fri, 20 Jan 2017 15:22:09 GMT

Sunny, It's interesting. As manish said i am also new to here. Anyhow, But how filter values are showing in expression even we use Variable here. Can you point out and help me on this

Re: What dos {$1} in the modifier do in Set Analysis

sunny_talwar — Fri, 20 Jan 2017 15:39:15 GMT

Its using this concept of Variables with Parameters

Re: What dos {$1} in the modifier do in Set Analysis

MK_QSL — Fri, 20 Jan 2017 15:42:19 GMT

Check the variable definition used in this expression..

Re: What dos {$1} in the modifier do in Set Analysis

bwisealiahmad — Sun, 22 Jan 2017 14:11:47 GMT

Hi again Sunny,

First of all thanks for the answer. This is what I was looking for. Do you know if this has any sort of memory saving or any better functionality in heavy straight tables? Moving the IF statement to a variable and then use parameters and variables in straight table?