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: 
naveen341
Creator
Creator

comparing Field Values in an if statement

Hi

I Have a field 

Tickers :

AAA

ACB

BCG

CDG

 

 

Suppose if a user select particular tickets lets say AAA i want to perform the measure like sum({<Ticker={'AAA'}>}Sales).

this would be in a qliksense line chart

If a user says more than one field values i am expecting multiple line in the line chart how can this be acheived?

I Am looking for if condition like getfieldselection(Ticker).But if multiple selected in differnet order this is not working

 

Any help would be appreciated

 

 

 

 

Labels (3)
14 Replies
dplr-rn
Partner - Master III
Partner - Master III

Basically something like.
If(getselectedcount(ticker)>0 and
SubStringCount(concat(ticker,'-'),'abc')>0
, Expression-for-abc)
naveen341
Creator
Creator
Author

Nope its not working.
Here is the screen shot like if multiple values are selected how will i check in if condition.

naveen341
Creator
Creator
Author

Atleast screen shot to original thread.Capture.pNG
dplr-rn
Partner - Master III
Partner - Master III

You are doing a wild match get field selections.

I would do wildmatch on the output of concat function

dplr-rn
Partner - Master III
Partner - Master III

Basically create multiple meaures each with the condition for ticker and appropriate measure