Create a dimension from 2 fields

[Anonymous]

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

[tom2qlik]

I would try an If Statement

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

Something like that.

[aarkay29]

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

[maxgro]

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