Interval Dimension

[master_student]

Hello everyone,

I need to create a calculated dimension : =If((CONGE ='N' and frac(DATE_DEB)= 0 ),'= 0',If((CONGE ='N' and count (distinct (DATE_DEB)) =2),'2',If((CONGE ='N' and count (distinct (DATE_DEB)) =1),'1', If((CONGE ='N' and count (distinct (DATE_DEB)) >=3),'3 ou plus'))))  / to get my data into intervals

but the probleme is that the result is :

do you have any idea ?

Thanks

[jonathandienst]

This statement will fail in a dimension:

frac(DATE_DEB)

To which value of DATE_DEB does this apply? QV has no way of knowing.

Consider doing this logic in the load script rather than a calculated dimension.

[MK_QSL]

May be try this...

=Aggr(If((CONGE ='N' and frac(DATE_DEB)= 0 ),'= 0',If((CONGE ='N' and count (distinct (DATE_DEB)) =2),'2',If((CONGE ='N' and count (distinct (DATE_DEB)) =1),'1', If((CONGE ='N' and count (distinct (DATE_DEB)) >=3),'3 ou plus')))) ,CONGE , DATE_DEB)

[master_student]

I tried in the script :

If((CONGE ='N' and frac(DATE_DEB)= 0 ),'= 0',If((CONGE ='N' and count (distinct (DATE_DEB)) =2),'2',If((CONGE ='N' and count (distinct (DATE_DEB)) =1),'1', If((CONGE ='N' and count (distinct (DATE_DEB)) >=3),'3 ou plus')))) as intervalll

and I delete the frac (DATE_DEB) from the script but it didn't work

[master_student]

Hello Manich

These is the result, not all intervalls in the dimension appears :

Thanks

[master_student]

Any help please?