Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sangeeth8787
Contributor III
Contributor III

Alternate State Set Analysis

Hi,

 

I have created two multi box with Group1 and Group2.

I am able to write set analysis difference between Group 1 and Group2.

How to achieve in set analysis

sum({<Group2[CountryCode] = Group1{Intracountry code}>}Value)

User had selected IntraCountryCode in Group1 Filters, but he don't want manually select CountryCode filter from Group2

I had tried following, but no luck

 

sum({<CountryCode = {"=(GetfieldSelection(IntracountryCode,'','Group1' "}>}Values) 

 

Is it feasible?

 

 

Many Thanks

 

 

 

Labels (1)
  • Other

1 Solution

Accepted Solutions
sunny_talwar

How about this?

Sum({Group2<[CountryCode] = P({Group1} [Intracountry code])>}Value)

View solution in original post

3 Replies
sunny_talwar

How about this?

Sum({Group2<[CountryCode] = P({Group1} [Intracountry code])>}Value)
sangeeth8787
Contributor III
Contributor III
Author

Hi,

Sum({[2nd Company]<yrperiod = {">$(20030001)<=$(=Lastperiod)"},InterCompany = p({[1st Company]}CmpCode)>}InterCompany_DocValue)

The above expression amended based your hint expression provided earlier, but it returning wrong values. 

 

sangeeth8787
Contributor III
Contributor III
Author

Sorry for earlier reply, It worked perfect! Many Thanks