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: 
bhanukoppera7491
Contributor II
Contributor II

How to write 2 expressions into a measure in a table

Hi,

I was wondering how to write multiple expressions in to a single measure.

I want to display 

Country   Sales

USA      $130 (5.6%)

India    $124(2.6%)

 

I tried to write an expression 

sum(Sales) & '(' & sum(Target) &')'  

which is not working. Can you please help me out.

1 Solution

Accepted Solutions
Mattie
Contributor
Contributor

Try this:

sum(Sales) & NUM(sum(Target), ' (#,##%)')

View solution in original post

1 Reply
Mattie
Contributor
Contributor

Try this:

sum(Sales) & NUM(sum(Target), ' (#,##%)')