Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

If Equals Certain Text, return a Date in a separate column

Hi, 

 

Have a column that contains materials for a project. I want to return the date a certain material was received on a dashboard. In Excel syntax it would be something like: 

 

If(Material = "Material A", RECEIVED_ON_DATE)

 

If anyone could help me with the correct syntax to return the date the material is received would be great. Also, would it be best practice to then display this date using the KPI widget? 

 

Thanks in advance

1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

Re: If Equals Certain Text, return a Date in a separate column

Try this as part of LOAD statement.

If(Material = 'Material A', RECEIVED_ON_DATE) As Date_Received

 If you have more Materials, then

If(Match(Material,'Material A','Material B'), RECEIVED_ON_DATE) As Date_Received

 

View solution in original post

2 Replies
Highlighted
Specialist III
Specialist III

Re: If Equals Certain Text, return a Date in a separate column

Try this as part of LOAD statement.

If(Material = 'Material A', RECEIVED_ON_DATE) As Date_Received

 If you have more Materials, then

If(Match(Material,'Material A','Material B'), RECEIVED_ON_DATE) As Date_Received

 

View solution in original post

Highlighted
Contributor
Contributor

Re: If Equals Certain Text, return a Date in a separate column

You got it @saran7de  thank you 🙂