Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Create a dimension from 2 fields

Hi there,

i have a date field [CF Date de livraison] that is sometimes empty. I want to create a dimension named [Date prevue] where when the field [CF Date de livraison] is empty, it takes the value from the field [Date confirme].

Is it an if function and how is the syntax?

Thank you,

Lawrence

4 Replies
tom2qlik
Creator
Creator

I would try an If Statement

If(isnull([CF Date de livraison]),  [Date confirme])

Something like that.

aarkay29
Specialist
Specialist


If( isnull([CF Date de livraison]), [Date confirme],[CF Date de livraison]) as [Date prevue]

maxgro
MVP
MVP

If( len(trim( [CF Date de livraison] )) > 0,

     [CF Date de livraison],

     [Date confirme]

) as [Date prevue]

MarcoWedel

Date(Alt( [CF Date de livraison] ,[Date confirme])) as [Date prevue]

Regards

Marco