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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Duggen
Contributor
Contributor

Issue with P&L Pivot dimension

Hi all

I´ve made a P&L Pivot, with 2 dimensions, one is a lot of sales rep´s, and the other Dimension have like 100 different values, but I only want to show one specific value...is it possible to write a string /formel in "Field" or "Label" so I only get this one value ?

 

 

 

(I know can make a filter andBI Question.png choose this specific value, but in this sheet I need 2

P&L Charts having different dimensions)

rgs

Duggen

 

Labels (3)
1 Reply
brunobertels
Master
Master

Hi 

May be like this 

Aggr( if( MyDim='A' OR MyDim ='B',MyDim, Mydim)