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: 
Ry2023NL
Contributor
Contributor

Create Master Item with only specifc values from a field

Hi all,

I have a field "Asset Class" with the following values

  • Asset Allocation
  • Bonds
  • Fixed Income
  • Equities

I would like to make a master item where the AA, Bonds & FI are then referred to as Fixed Income 

I was able to create one for equities using the formula: =if([Asset class]='Equities',[Asset class],Null())

But when I try to create for  Fixed Income (FI + Asset Allocation + Bonds) it doesn't work. 

What would be the correct way to do this? (tbf, I don't believe the Equities formula is the best way to go about it, but that one worked...)

Thanks!

Labels (3)
1 Reply
WildmoserGeorg
Contributor III
Contributor III

 

hi,

maybe it works if you limit the selection via set analysis.

formula in master element:

=aggr(only({<h1={"b"}>}h1),h1)

WildmoserGeorg_2-1678118089305.png

 

WildmoserGeorg_0-1678118018342.png

WildmoserGeorg_1-1678118045262.png

 

script in data editor:

trans:
load * inline [
h1
a
b
]