Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shwetagupta
Partner - Creator II
Partner - Creator II

Class Function using Aggr

Hi,

I am using following expression in the dimension

=IF((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))=0,'0',
     IF((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))<50 and(Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))>0,
         Class((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo)),25,''),
             IF((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))>50, Class((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo)),25,''))))


Things looks fine if I plot this in table but When I am plotting above expression as dimension it is giving me the following ranges:

    0
     25<=<50                     ---------- Here 0-25 slab is missing on dimension. Please  explain
     50<=<75

Can some one please help!

4 Replies
pathiqvd
Creator III
Creator III

Hi,

try this,

=IF((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))=0,'0',

     IF((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))<=25 and(Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))>0,

         Class((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo)),25,''),

             IF((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))>50, Class((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo)),25,''))))

Regards,

pathiqvd
Creator III
Creator III

Or try this,

=IF((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))=0,dual('0',1),

IF((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))<=25 and(Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))>0,dual('0-25',2),

IF((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))<=50 and(Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))>=26,dual('26-50',3),

IF((Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))<=75 and(Aggr(Max(Date),SerialNo)- aggr(Min(Date),SerialNo))>=51,dual('51-75',4)))))

vinieme12
Champion III
Champion III

What does this do?

=AGGR( CLASS ( Max(Date)  - Min(Date),25) , SerialNo )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sunny_talwar

May be this

=Aggr(If((Max(Date) - Min(Date)) = 0, '0', Class((Max(Date) - Min(Date)), 25)), SerialNo)