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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator III
Creator III

Range selection

HI Community,

I facing one problem..

I would like to create range wise chart..

If I am give range From and to

I want to filter data..

Example:

Client,  Type, Amount

A, AC, 100

A, AC,200

A,AC,400

B,AC,30

B, AC, 50

C, AC, 250

C, AC, 45

Chart:

Client   Type  Sum(Amount)

A            AC      700

B            AC        80

C           AC        295

Here My requirement..

Range  From:   50

             To:      500

Output Should Be

Client   Type  Sum(Amount)

B            AC        80

C           AC        295

Thanks In Advance...

4 Replies
Kushal_Chawda

try expression

Sum({<Client ={"=sum(Amount)>=50 and sum(Amount)<=500"}>}Amount)

MK_QSL
MVP
MVP

Use this..

sunny_talwar

May be like attached

Capture.PNG

Chanty4u
MVP
MVP

chk attachmnt