topic Re: Set Analysis & variables in QlikView

Set Analysis & variables

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

why is the following set analysis not working:?

sum({<Tree Name]=,Tree Group]={'$(=only([Tree Group]))'}, [ID]=,[Number Of Trees= >} ({$(=vExpTotal )}* 1000))

this variable vExpTotal is using another variable. Do I have to do something to the first variable?

Re: Set Analysis & variables

sunny_talwar — Thu, 29 Sep 2016 10:13:05 GMT

May be because you are missing some square brackets or is that a typo?

Sum({<[Tree Name]=,[Tree Group]={'$(=only([Tree Group]))'}, [ID]=,[Number Of Trees]= >} ({$(=vExpTotal )}* 1000))

Re: Set Analysis & variables

Anonymous — Thu, 29 Sep 2016 10:16:32 GMT

Does Syntax of your expression is okay?

Some where you forgot to place '[' bracket...and some where you forgot to place ']'..

may be this?

=sum({<[Tree Name],[ID],[Number Of Trees],[Tree Group]={'$(=only([Tree Group]))'} >} ($(=vExpTotal ))*1000)

Re: Set Analysis & variables

Thu, 29 Sep 2016 10:22:46 GMT

Can you try this

=sum({<[Tree Name]=,[Tree Group]={'$(=only([Tree Group]))'}, [ID]=,[Number Of Trees]= >} $(=vExpTotal )* 1000)

Re: Set Analysis & variables

Anonymous — Thu, 29 Sep 2016 10:31:26 GMT

this is not the correct answer

Re: Set Analysis & variables

Anonymous — Thu, 29 Sep 2016 10:32:12 GMT

this is not the correct answer

Re: Set Analysis & variables

sunny_talwar — Thu, 29 Sep 2016 10:32:31 GMT

Why did you mark it as correct response my friend?

Re: Set Analysis & variables

Anonymous — Thu, 29 Sep 2016 10:35:06 GMT

I did not say "my answer is correct". I just asked to try like this?

Re: Set Analysis & variables

Colin-Albert — Thu, 29 Sep 2016 10:58:09 GMT

What does the variable vExpTotal hold?

This variable may be incompatible with the rest of your expression.
What happens if you replace ($(=vExpTotal )) with a different field for testing?