topic Set analysis with variable in QlikView

Set analysis with variable

Mon, 20 Oct 2014 08:15:20 GMT

Hello everybody,

I have a silly problem about Set Analysis that I wasn't able to solve reading all the manuals and examples I found on internet.

I need to compare a field to a variable inside the modifier.

I have Pax associated to some IDs. I want the Sum of Pax for only a specific ID, contained in the variable vID1 (it is the latest ID obtained with the function rank, but I tested and it works)

Sum ({$<ID={"$(vID1)"}>} Pax)

Probably I am doing a mistake in the sintax, but I can't understand where!

Thanks!

Matt

Re: Set analysis with variable

ashfaq_haseeb — Mon, 20 Oct 2014 08:22:03 GMT

Hi,

Try like this

Sum ({$<ID={"$(=vID1)"}>} Pax)

Sum ({$<ID={'$(=vID1)'}>} Pax)

Regards

ASHFAQ

Re: Set analysis with variable

Mon, 20 Oct 2014 08:24:42 GMT

Hi,

May be Try like below:

Sum ({$<ID={">=$(vID1)<=$(vID1)"}>} Pax)

Best,

Robert

Re: Set analysis with variable

Mon, 20 Oct 2014 08:35:51 GMT

All 3 formulas gave me 0 as result.

If i write the formula without the Variable but with the # of the ID i get the sum of pax.

If i test the variable with (vID) i get the right id.

If I put them together it doesn't work.

Thanks

Matt

Re: Re: Set analysis with variable

ashfaq_haseeb — Mon, 20 Oct 2014 08:39:26 GMT

Hi,

Sample application attached for you.

Set analysis is case sensitive make sure you have same field name.

If possible post your application to help you with.

Regards

ASHFAQ

Re: Set analysis with variable

simondachstr — Mon, 20 Oct 2014 08:42:57 GMT

Try Sum ({$<ID={'$(=$(vID1))'}>} Pax)

Re: Set analysis with variable

maxgro — Mon, 20 Oct 2014 08:49:43 GMT

to debug set analysis

add a chart with only your expression, remove label as in image

and let we know the output

Re: Set analysis with variable

Mon, 20 Oct 2014 08:58:20 GMT

Hi Mohammed,

I added a variable that rank the ID (like in my original case). Doing that your set analysis doesn't work anymore.

And it's the exact same case that I am facing, and I am not able to see what I am missing.

Thanks

Matt

Re: Set analysis with variable

ashfaq_haseeb — Mon, 20 Oct 2014 09:01:57 GMT

Hi,

Without seeing code its hard to analyze.

did you follow Massimo Grossi suggestion.

If possible post sample Application to look over.

Regards

ASHFAQ

Re: Set analysis with variable

Mon, 20 Oct 2014 09:03:12 GMT

I added the chart as you told to the example I sent back to Mohammed, that's the output:

I don't get any error in the expression, but the sum it's just 0

Re: Set analysis with variable

ashfaq_haseeb — Mon, 20 Oct 2014 09:06:59 GMT

Hi,

Can you expand this image fully.

I need to see complete code.

Regards

ASHFAQ

Re: Set analysis with variable

Mon, 20 Oct 2014 09:09:43 GMT

I meant to send you back the file but I forgot to attach it

And now I am trying to figure out how to attach it

Re: Set analysis with variable

Mon, 20 Oct 2014 09:11:13 GMT

Re: Set analysis with variable

ashfaq_haseeb — Mon, 20 Oct 2014 09:12:55 GMT

See,

Your variable is not returning anything you need to fix that.

As it returns null, therefore you get zero.

Regards

ASHFAQ

Re: Set analysis with variable

jagan — Mon, 20 Oct 2014 09:18:16 GMT

Hi,

Check your variable in Text object by giving

=vID1

Currently your variable is giving null value, that is why you are getting 0. Fix the variable definition, automatically the set analysis expression works.

Hope this helps you.

Regards,

Jagan.

Re: Re: Set analysis with variable

Mon, 20 Oct 2014 09:19:19 GMT

Hi Mohammed,

the problem is that the variable works outside the set analysis (see attached).

But it doesn't work when embedded in set analysis.

Thanks!

Matteo

Re: Re: Set analysis with variable

Mon, 20 Oct 2014 09:22:51 GMT

Hi jagan,

I attached the file, I checked the variable in a textbox and the result is correct.

That's why I can't explain what's wrong with the set analysis, since the variable works by itself.

Thanks!

Matt

Re: Set analysis with variable

jagan — Mon, 20 Oct 2014 09:28:06 GMT

Hi,

What is your expected output? Can you come up with an example. You are using vID1 or vIDMax in expression?

Regards,

Jagan.

Re: Set analysis with variable

ashfaq_haseeb — Mon, 20 Oct 2014 09:29:05 GMT

Hi,

You need to fix your variable.

Variable is not working outside even

instead of Rank(ID) try with Max(ID) as your variable definition.

Can you come up with proper explanation for what purpose you need rank here.

Regards

ASHFAQ

Re: Re: Set analysis with variable

Mon, 20 Oct 2014 09:31:22 GMT

I need to use vIDMax (the one with rank formula)

Thanks

Matt