The Wigner function and its relation with the wavelet transform for certain Lie groups