Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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!