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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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!

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

Maybe like this?

Sum

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

View solution in original post

2 Replies
swuehl
Champion III
Champion III

Maybe like this?

Sum

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

Not applicable
Author

worked like a charm, thanks!