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: 
Not applicable

I need some help to limit my data

Hi!

I have a dimension called Business Unit which I would like to limit to the value BIG in one of my graphs, hope you can help me.

The expression is "Net Sales (' & Valuta &') and I want the definition to limit the result to Business Unit BIG if possible?

The Defiinition of Net Sales is currently:

Sum

({<RRResultatPost = {'Net Sales'}>} Amount_$(vCurr)

Thanks!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like this?

Sum

({<RRResultatPost = {'Net Sales'}, [Business Unit]= {'BIG'} >} Amount_$(vCurr) )

View solution in original post

2 Replies
swuehl
MVP
MVP

Maybe like this?

Sum

({<RRResultatPost = {'Net Sales'}, [Business Unit]= {'BIG'} >} Amount_$(vCurr) )

Not applicable
Author

worked like a charm, thanks!