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: 
Sxbbb
Creator III
Creator III

I want to display only matching Workorder data.

EX. 

There is a WorkOrder with 3 data values

Sxbbb_0-1676344854317.png

 

i use code

Suchanan_1-1676343414491.png

Result 

but showing Open for every WorkOrder

Sxbbb_1-1676344883400.png

It has to be Open 3
Only matches the WorkOrder with data. 

I want Open to show only WorkOrder values.

 

6 Replies
MayilVahanan

Hi

You can add if condition based on ur condition like

If(Match(WorkOrder, 'a', 'b', 'c'), 'Open URL', '')

Instead of a, b, c, u can change based on ur scenario

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Sxbbb
Creator III
Creator III
Author

different workOrder numbers after A . 

WorkOrder Example

 

Sxbbb_1-1676347650483.png

 

 

Sxbbb
Creator III
Creator III
Author

WorkOrder Example

Sxbbb_0-1676347905205.png

 

MayilVahanan

So, you want to check the work order starts with A?

If so, try like below

If(wildMatch(WorkOrder, 'A*'), 'Open URL', '')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Sxbbb
Creator III
Creator III
Author

No, I need it to match every WorkOrder to show Open.
Sxbbb
Creator III
Creator III
Author

I want workorder to match every number