Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-04-23 10:15 AM

Margin %

Hi,

I am trying to get a margin percentage in a straight table.  I found another discussion that said to use sum(sales)/sum(cost).  I when I click apply, the whole row shows as -.   Any suggestions on what I might try instead?  Thanks.

287 Views
0 Likes
2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2013-04-23 10:42 AM

Hi,

     Kindly post the QVW file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
176 Views
0 Likes
MayilVahanan
MVP
MVP
‎2013-04-23 03:29 PM

Hi

Check whether sum(cost) gives null value or zero? If so, it display "-".

= sum(sales)/Alt(sum(cost),1)

please make sure, that field name are correct too.

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
176 Views
0 Likes