topic Re: Chart function - filtering out data. in QlikView

Chart function - filtering out data.

qlikaddict — Fri, 25 May 2018 15:26:05 GMT

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 — Fri, 25 May 2018 16:00:17 GMT

hello

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

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

qlikaddict — Fri, 25 May 2018 16:59:09 GMT

Thanks for your reply, but it doesnt work.

The modifier field cant be a measure isnt it?

qlikaddict — Fri, 25 May 2018 17:15:38 GMT

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 — Tue, 29 May 2018 14:09:16 GMT

Hi,

Try like this.

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

vishsaggi — Tue, 29 May 2018 14:23:41 GMT

Try this in your straight table expr:

Add Dimensions:

Dim1, Dim2

Expression:

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