Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
suryaa30
Creator II
Creator II

Selection Value for a calculated Field

Hi 

Straight Table

I am trying to create a List box for a calculated field  "Change"created on front end using Column() function. 

=If(Column(1)=Column(2),'No','Yes')

 

Qlik.PNG

I want Yes and No to be displayed in list box all the time.

I am loading a inline table to ensure list box displays both Yes and No at all times.

Can someone help link the inline table list box selection to straight table

 

 

 

 

 

1 Reply
prabhu0505
Specialist
Specialist

create listbox with below expression

=If(Aggr(only(Qty1)=only(Qty2), Claim, Event)=0, 'Yes', 'No')