Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
robertocesp
Contributor II

Group filter?

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?

Tags (1)
5 Replies

Re: Group filter?

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

vinieme12
Esteemed Contributor II

Re: Group filter?

Try with IntervalMatch()

Days:

Load * inline [

Days

10

11

20

25

30

45

50

51

59

61

65

68

70

71

72

80

82

85

89

90

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;

robertocesp
Contributor II

Re: Group filter?

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

Re: Group filter?

Not sure I understand your comment?

robertocesp
Contributor II

Re: Group filter?

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