Discussion board where members can get started with Qlik Sense.
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
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
You got it @saran7de thank you 🙂