Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-04-13 07:22 PM

help with expression

I need to calculate the status by day , if there is one failure per day .. the status is fail ,if all statuses are success then success ..

so basically i need a new column with one status either fail or success, below is my sample data i am aggregating the data by date and concatenating the status

1.jpg

385 Views
0 Likes
2 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-04-13 09:40 PM

May be create one line in script

If(SubStringCount(DataStatus, 'failure','failure'), 'success')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
306 Views
tresesco
MVP
MVP
‎2017-04-14 12:55 AM

Try like:

If(SubStringCount(Concat(DataStatus), 'failure'),'failure', 'success')

306 Views