topic Re: Group analysis and set analysis without write all fields in QlikView

Group analysis and set analysis without write all fields

pljsoftware — Tue, 20 Dec 2011 18:03:59 GMT

Hi,

I want to use altenate state to make analysis on 2 periods, for this I use 2 alternate state "Period1, Period2" and I have set this on Year and Month fields.

Now when I create my chart and I write the expression do

=sum ({[Period1] <AgentName=$::[AgentName], Region=$::[Region], LocalState=$::[LocalState], Product=$::[Product] >} Quantity)

=sum ({[Period2] <AgentName=$::[AgentName], Region=$::[Region], LocalState=$::[LocalState], Product=$::[Product] >} Quantity)

Exist a way to don't write the part between < ... >?

I have many fields and is boring to write always all fields only to specify $::

Regards

Luca Jonathan Panetta

PLJ Software

Group analysis and set analysis without write all fields

brenner_martina — Wed, 21 Dec 2011 08:42:26 GMT

Hi, Luca,

try something like this, where FIELDNAME is the field you select in your alternate states:

=sum({<FIELDNAME = [Period1]::FIELDNAME>} Sales)

Greetings from Munich
Martina
EVACO GmbH

Group analysis and set analysis without write all fields

kamalqlik — Wed, 21 Dec 2011 08:49:17 GMT

Hi ,Luca...you can use a variable and each time write the variable to get the appropiate results////

regards

Kamal

Re: Group analysis and set analysis without write all fields

pljsoftware — Wed, 21 Dec 2011 13:18:13 GMT

Hi Kamal,

yes, I can use a variable but I want to find a new way to do this.

Edit: want to

Regards

Luca Jonathan Panetta

PLJ Software

Group analysis and set analysis without write all fields

kamalqlik — Thu, 22 Dec 2011 04:40:06 GMT

Hi Luca...can you shate the new method of solving this with...I will be thankfull to you.

regards

Kamal