Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikaddict
Contributor II
Contributor II

Chart function - filtering out data.

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.

5 Replies
olivierrobin
Specialist III
Specialist III

hello

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

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

qlikaddict
Contributor II
Contributor II
Author

Thanks for your reply, but it doesnt work.

The modifier field cant be a measure isnt it?

qlikaddict
Contributor II
Contributor II
Author

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
Master II
Master II

Hi,

Try like this.

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

Capture.JPG

vishsaggi
Champion III
Champion III

Try this in your straight table expr:

Add Dimensions:

Dim1, Dim2

Expression:

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