topic Re: Referencing Expression in SET ANALYSIS in QlikView

Referencing Expression in SET ANALYSIS

Anonymous — Fri, 23 Jun 2017 16:42:07 GMT

I am trying to reference an Expression within SET ANALYSIS, but I am having some difficulties.

I have an expressions as follows:

SET IRRAdverseCase =

IF(Region = 'Canada Region',
'Scenario I',
IF(Region = 'US Region',
'Scenario I',
'Scenario II')) ;

I then have an equation, which references the previous expression:

SUM(
{<
Scenario = {'$(IRRAdverseCase)'}
>}
[ParCr])

When I try to evaluate the expression, it comes up as zero (0). However, if I hard code the Scenario as follows, it produces the correct result:

SUM(
{<
Scenario = {'Scenario I'}
>}
[ParCr])

I am wondering if anyone knows why this is happening. I would appreciate some help with referencing the Scenario, as opposed to hard coding it because it could change.

Re: Referencing Expression in SET ANALYSIS

sunny_talwar — Fri, 23 Jun 2017 16:43:16 GMT

What if you try like this (Without single quotes around your variable)

SUM(
{<
Scenario = {$(IRRAdverseCase)}
>}
[ParCr])

Re: Referencing Expression in SET ANALYSIS

Sergey_Shuklin — Fri, 23 Jun 2017 16:44:15 GMT

Hello, Michael!

Try

SUM(
{<
Scenario = {"$(IRRAdverseCase)"}
>}
[ParCr])

Re: Referencing Expression in SET ANALYSIS

Anil_Babu_Samineni — Fri, 23 Jun 2017 16:46:04 GMT

You already define variable in Single Quote, So you don't require Single Quote over Set analysis for that variable

Re: Referencing Expression in SET ANALYSIS

Anonymous — Fri, 23 Jun 2017 16:46:10 GMT

Hi, thanks for the response, but I had tried changing the quotes to "", but it still came up as zero (0)

Re: Referencing Expression in SET ANALYSIS

Anonymous — Fri, 23 Jun 2017 16:46:57 GMT

Unfortunately I tried this approach, and it the output of the expression was still zero (0). So single quotes, double quotes and no quotes all produce zero (0).

Re: Referencing Expression in SET ANALYSIS

sunny_talwar — Fri, 23 Jun 2017 16:47:08 GMT

Actually it worked for me with the single quotes

Re: Referencing Expression in SET ANALYSIS

Anonymous — Fri, 23 Jun 2017 16:51:15 GMT

Well, actually my expression for 'IRRAdverseCase' is actually a series of equations, so it is not just hard-coded -- guessing that might be what is causing the issue.

Re: Referencing Expression in SET ANALYSIS

Peter_Cammaert — Fri, 23 Jun 2017 16:57:36 GMT

Then why don't you post the "real" expression for IRRAdverseCase. Maybe we can still help you figuring out how to get this into shape?

Re: Referencing Expression in SET ANALYSIS

sunny_talwar — Fri, 23 Jun 2017 17:02:10 GMT

What do you see in variable overview after the script runs through?

Re: Referencing Expression in SET ANALYSIS

Anonymous — Fri, 23 Jun 2017 17:03:20 GMT

Please note that I have updated the description to include the equation.

I am thinking that the issue is because I already have quotes in the IF statement for the variable 'IRRAdverseCase ', but I could be wrong

Re: Referencing Expression in SET ANALYSIS

sunny_talwar — Fri, 23 Jun 2017 17:05:06 GMT

So you will have only one region selected when you plan to look at this?

Re: Referencing Expression in SET ANALYSIS

Anonymous — Fri, 23 Jun 2017 17:05:27 GMT

I think we need to see what your variable really is. And see what it is evaluating to.

Sounds like the issue may not be in your set analysis expression but in your variable evaluation.

Re: Referencing Expression in SET ANALYSIS

sunny_talwar — Fri, 23 Jun 2017 17:07:42 GMT

May be try this

=SUM(

Scenario = {'$(=$(IRRAdverseCase))'}

[ParCr])

When US Region or Canada Region is selected

When Asia Region is selected

Re: Referencing Expression in SET ANALYSIS

Anonymous — Fri, 23 Jun 2017 17:11:20 GMT

Please note that when I look at the Variable Overview, it just has the equation:

IF(Region = 'Canada Region',
'Scenario I',
IF(Region = 'US Region',
'Scenario I',
'Scenario II'))

Re: Referencing Expression in SET ANALYSIS

sunny_talwar — Fri, 23 Jun 2017 17:17:00 GMT

Try this (sample attached in one of the below posts)

=SUM(

Scenario = {'$(=$(IRRAdverseCase))'}

[ParCr])

Re: Referencing Expression in SET ANALYSIS

Anonymous — Fri, 23 Jun 2017 17:18:26 GMT

Thank you very much! This worked perfectly.

For my own knowledge, why would I have to put in a double $?

Re: Referencing Expression in SET ANALYSIS

sunny_talwar — Fri, 23 Jun 2017 17:21:11 GMT

I guess the issue is that your variable isn't defined with an equal sign, so it needs to be evaluated before it can bed used in the set analysis syntax...

So inner set analysis evaluates it to 'Scenario I' and outer one is used for set analysis...

Alternatively you can define your variable like this

SET IRRAdverseCase = =IF(Region = 'Canada Region', 'Scenario I', IF(Region = 'US Region', 'Scenario I', 'Scenario II'));

And then this should work

=SUM(

Scenario = {'$(=IRRAdverseCase)'}

[ParCr])

Inner dollar sign expansion is not needed because you have an equal sign in your set statement.