Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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)
1 Solution

Accepted Solutions

How about this?

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

View solution in original post

3 Replies

How about this?

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

View solution in original post

Highlighted
Contributor III
Contributor III

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. 

 

Highlighted
Contributor III
Contributor III

Sorry for earlier reply, It worked perfect! Many Thanks