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

How to compare and combine the data?

Hi All,

I have two fields Date and Status. For each date I have multiple statuses. Based on those multiple statuses I want to create one value for each date.

Input data:

DateStatus
Jun-19Submitted
Jun-19Partially Submitted
May-19Submitted
May-19Submitted
Apr-19Partially Submitted
Apr-19Partially Submitted

  

Here I have two statuses (i.e. Submitted and Partially submitted). If the corresponding date has only Submitted status then I want to display it has 'Fully Submitted' for that date. If it has atleast one 'Partially Submitted' then i want to display 'In Progress' for that Month.

I have build a logic, which is only working for June and May but not for April.

Desired Output:

DateStatus1
Jun-19In Progress
May-19Fully Submitted
Apr-19In Progress

 

Can anyone please help me with this?

Please find the attached QVW and source file. 

Thanks in advance!

Cheers,

Varun

 

 

Labels (1)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

change your load script to use below instead of the count

 

if( index(Concat(Status),'Partially Submitted')>0,'In Progress','Completed' ) as Status1

View solution in original post

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

change your load script to use below instead of the count

 

if( index(Concat(Status),'Partially Submitted')>0,'In Progress','Completed' ) as Status1