Chart function - filtering out data.

[qlikaddict]

Hi,

I have a chart that has 2 dimensions and a measure.

Dim1, Dim2, Measure

A        11      1

B        12       2

C        13       1

D        22      3

E        22      5

F        33      6

I want to get the records that are less than or equal to 3, how would I achieve that?

thanks.

[olivierrobin]

hello

in your chart, use a set analysis in expression, something like

sum({<Measure="<3">}Measure)

[qlikaddict]

Thanks for your reply, but it doesnt work.

The modifier field cant be a measure isnt it?

[qlikaddict]

Found another way, not sure if this is the best approach..but it works!

=sum(if(Aggr(sum(Measure)Dim1,Dim2) < 3,1,0))

[qlikviewwizard]

Hi,

Try like this.

sum( {$ <Dim1={"=sum(Measure)<=3"} >} Measure)

[vishsaggi]

Try this in your straight table expr:

Add Dimensions:

Dim1, Dim2

Expression:

= Sum({< Measure = {'<=3'} >} Measure)