Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mandilicious
Creator II
Creator II

Qliksense cal

Hi All

Please help me out i have below table. in this table i need to calculate like: if Due Date is D+0 it should count from 1 upwards e.g total is 1+2+2+1 = 6 and  if Due Date is D+3 it should count from 4 upwards e.g total is 2  = 2. please help i cant get the logic behind that?

Thanks

1 Solution

Accepted Solutions
dan_sullivan
Creator II
Creator II

IF([Due Date] = 'D+3' , Count({$<[Reason_Aging]={'>=4'}>}[DimensionYouAreCounting]),

IF([Due Date] = 'D+1' , Count({$<[Reason_Aging]={'>=2'}>}[DimensionYouAreCounting]),

IF([Due Date] = 'D+2' , Count({$<[Reason_Aging]={'>=3'}>}[DimensionYouAreCounting]) )))

Something like this i would guess.

View solution in original post

4 Replies
dan_sullivan
Creator II
Creator II

what is the dimension being used to create third column of your example?

mandilicious
Creator II
Creator II

HI Dan

Thanks for your respond i used  Reason_Aging as my dimension.

Thanks

dan_sullivan
Creator II
Creator II

IF([Due Date] = 'D+3' , Count({$<[Reason_Aging]={'>=4'}>}[DimensionYouAreCounting]),

IF([Due Date] = 'D+1' , Count({$<[Reason_Aging]={'>=2'}>}[DimensionYouAreCounting]),

IF([Due Date] = 'D+2' , Count({$<[Reason_Aging]={'>=3'}>}[DimensionYouAreCounting]) )))

Something like this i would guess.

View solution in original post

mandilicious
Creator II
Creator II

Thanks Dan it is working perfectly.