- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to remove specific values of a field in a sum expression
Hello everyone,
I need to create a bar chart which displays the sum of specific values of a field called "Categoria".
Below is the printscreen of the field in my data base:
I donĀ“t want to sum the values "Mulheres" and "Homens", it should be removed from the result of the sum.
Thanks,
- Tags:
- new_to_qlikview
- Ā« Previous Replies
-
- 1
- 2
- Next Replies Ā»
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You want at dimension level or Expression level?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try dis,
sum( {<Categoris= {'Mulheres','Homens'}>} Categoris )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
At dimension level you can try like:
Edit your dimension with:
if(Categoria<>'Mulheres' and Categoria<>'Homens', Categoria)
At Expression level you can do:
sum({<Categoria={'*'}-{'Mulheres','Homens'}>} Field) //as per your requirement
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
sum( {<Categoris -= {'Mulheres','Homens'}>} Categoris )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your help guys.
I forgot to say that i need to divide the result of the sum by the value of "Regular Employee" of each year.
For example, here is the sum from 2014:
And than, i need to divide the result of the sum (1295), by the value of "Regular Employee" (897) of the same year:
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
then try this:
=(sum(YourField12)/sum({<YourField={'Regular Employee'}>} YourField12))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In brief after your requirement sharing:
Take this as a Dimension:
if(Categoria<>'Mulheres' and Categoria<>'Homens', Categoria)
and
Expression: =(sum(Amount)/sum({<Categoria={'Regular Employee'}>} Amount))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Somenthig went wrong, here are the values displayed:
I guess the sum expression is not doing the sum by year.
Note that Year is a dimension of my chart.
- Ā« Previous Replies
-
- 1
- 2
- Next Replies Ā»