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: 
dondapati
Contributor II
Contributor II

Reference One Column selection to another column, from list box

Hello all,

In Text box , if user selected value from the list box, it reference to another column , corresponding matching rows.

Here my data looks like 

 

CompanyCombined_TypePlaceProdType
NAHVAN/MVAN, PUP-D - HeavyOh15992PUP-D - Heavy
NAHVAN/MVAN, PUP-D - HeavyOh16239PUP-D - Heavy
NAHVAN/MVAN, PUP-D - HeavyOh52146HVAN/MVAN
NAPUP-D - Heavy, EKen257E
NAPUP-D - Heavy, EKen957E
NAPUP-D - Heavy, EKen352PUP-D - Heavy
NBPUP-D - HeavyFly1517PUP-D - Heavy
NBPUP-D - HeavyFly2014PUP-D - Heavy
NBPUP-D - HeavyFly79037PUP-D - Heavy
NBPUP-D - HeavyFly92192PUP-D - Heavy
     

 

Expect Combined_Type, Prod everything is available in list box.

if user select the Value Type = "E" and Plan = "Ken" then Combined_Type list contains value's sum prod(257, 957, 352) value come.

because, here Combined_Type  column contains the "E"

 

I tried the trigger  on Type column

WildMatch(Combined_Type, '*'& getfieldselections([Type],'*|*')) 

But it not working,

Update:

I Tried Following 

sum( DISTINCT {<[Type] = { "$(=GetFieldSelections([Type]))"}>} Production )

how to check 

sum( DISTINCT {<[Combined_Type] = { "$(=GetFieldSelections([Type]))"}>} Production ) (Matching which are in Combined_Type)


Help me, how to reference one column to another column 

 

 

Labels (1)
2 Replies
Chanty4u
MVP
MVP

can you try this?

=Sum({<Type = p(Type)>} Prod)

Ref.PNG

dondapati
Contributor II
Contributor II
Author

Hi Chanty4u, Thank you for given reply.

Maybe i am not explain clearly, sorry for that.

 

In the same thing , if i include the list box for Type column and select value is E , then also the value is 1566 ,

because the selected value "E" is in 3 rows , with Combined_Type Column.
In the front end i can't place the Combined_Type Colum as List box.