topic Re: Group filter? in QlikView

Group filter?

Anonymous — Fri, 31 Mar 2017 13:11:23 GMT

Hi,

I have a field called days, that count the number of days passed since the beginning of the request to the end.

I need to create a group filter, this is what I did:

- have a field expression with

=If (Days <=30, '1 to 30 Days',
If (Days >90,'90 + Days',
If (Days >60, '60 + Days',
If (Days>45, '45 + Days',
If (Days>30, '30 + Days')))))

The problem is that when you select '45 + Days' should include '60 + Days' and '90 + Days', or if I select '60' should include 90, and 30 should include 45, 60 and 90.

Can you please help me to do this?

Re: Group filter?

sunny_talwar — Fri, 31 Mar 2017 13:19:43 GMT

Seems like you are looking to get accumulation of your expression? Is that right? If it is, then use RangeSum(Above()) or use Full accumulation in your chart

Re: Group filter?

vinieme12 — Fri, 31 Mar 2017 13:27:34 GMT

Try with IntervalMatch()

Days:

Load * inline [

Days

100

];

Intervals:

Load * Inline [

FromDay,ToDay,DayGroup

0,29,<30

30,1000,>30

45,1000,>45

90,1000,>90

];

IntervalMatch:

IntervalMatch (Days)

Load distinct FromDay, ToDay resident Intervals;

Re: Group filter?

Anonymous — Fri, 31 Mar 2017 14:08:10 GMT

How can I use that in an easy expression as what I did before?

Re: Group filter?

sunny_talwar — Fri, 31 Mar 2017 14:12:38 GMT

Not sure I understand your comment?

Re: Group filter?

Anonymous — Fri, 31 Mar 2017 14:18:36 GMT

I need the accumulation, how can I use the RangeSum in my expression?