Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

NEED HELP

Hi guys,

Is it possible calculate sum used distinct from other variable?

Like this

sum( DISTINCT A (B))

I need sum B, but B multiplies some times.

Thanks,

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I use sum({<A={'1'} B)

I can use this expression in textbox and in chart

View solution in original post

6 Replies
sujeetsingh
Master III
Master III

Just paste a sample and explain in details.

Not applicable
Author

post a sample file ..it is defintley possible....

Anonymous
Not applicable
Author

Hi,

Please see attached files.

Thanks,

Anonymous
Not applicable
Author

Hi,

Please see attached files.

Thanks,

Anonymous
Not applicable
Author

Any ideas?

Anonymous
Not applicable
Author

I use sum({<A={'1'} B)

I can use this expression in textbox and in chart