Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Could you please help me in replacing the empty space with the word others.
I tried the mapping but it is not working:
mapservicestatus2:
mapping load * inline [
raison_refus_rendez-vous,Newraison_refus_rendez-vous
Null(), Autres
] ;
AS_XX_XXX:
ApplyMap('mapservicestatus2',[raison_refus_rendez-vous]) as [Newraison_refus_rendez-vous];
And this is my expression:
=Count({<Marquenew={'Citroën'}>}{<[Newraison_refus_rendez-vous]={'Rendez-vous déjà fixé','Véhicule vendu','Entretien déjà effectué','Autres'}>} [Newraison_refus_rendez-vous])
Any idea where I am wrong?
Many Thanks,
Hasvine
I think the '-' values in the chart are 'missing' rather than null and neither script deals with that. I suggest that you post your qvw or a representative sample to see why those values are missing and what can be done to resolve that.
Hi Hasvine,
Seems the cell value is "{null}".!!! If so try the below one,
TableName:
LOAD
*,
If([raison_refus_rendez-vous] ='{null}' , 'Autres', [raison_refus_rendez-vous]) as [Newraison_refus_rendez-vous]
FROM DataSource;