Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ramya_beginner
Creator
Creator

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

2 Replies
Anil_Babu_Samineni

May be create one line in script

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tresesco
MVP
MVP

Try like:

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