Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pljsoftware
Creator III
Creator III

Group analysis and set analysis without write all fields

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

4 Replies
brenner_martina
Partner - Specialist II
Partner - Specialist II

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

kamalqlik
Partner - Specialist
Partner - Specialist

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

regards

Kamal

pljsoftware
Creator III
Creator III
Author

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

kamalqlik
Partner - Specialist
Partner - Specialist

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

regards

Kamal