topic Re: Interval Dimension in QlikView

Interval Dimension

master_student — Mon, 07 Nov 2016 08:27:15 GMT

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

Re: Interval Dimension

jonathandienst — Mon, 07 Nov 2016 08:38:48 GMT

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.

Re: Interval Dimension

MK_QSL — Mon, 07 Nov 2016 08:42:36 GMT

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)

Re: Interval Dimension

master_student — Mon, 07 Nov 2016 08:50:41 GMT

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

Re: Interval Dimension

master_student — Mon, 07 Nov 2016 09:46:00 GMT

Hello Manich

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

Thanks

Re: Interval Dimension

master_student — Tue, 08 Nov 2016 15:26:07 GMT

Any help please?