Specify X Axis Values

[Qliksenseranelx5]

I have a bar chart with employees names on the x-axis and days absent on the y axis. I only want to display a specific set of employees and need help with an expression. Any ideas?

[dplr-rn]

Sure..
use set analysis to limit the emplyees
e.g.
Sum({Employee={'ABC','XYZ'}}Sales)
shows only for abc and xyz

question is how how you determine which employees you want to show. if theres a spefic logic you can use set analysis for the same too rather than hard coding as i did above

[Qliksenseranelx5]

Thanks dilipranjith i'll try that. Right now there isn't anything unique, i can add something in the data model to differentiate them and use the set analysis. I'll let you know if it works.

[dplr-rn]

no prob.
close thread as answered if it does

[Qliksenseranelx5]

Ok, follow up question. If my employee dimension is named Employee and the days absent is named Days would the expression be =Sum({Employee={'ABC','XYZ'}}Days)

[dplr-rn · Accepted solution]

Apologies. i messed up in the initial reply
Set analysis should be inside {<....>}. updated below
Sum({<Employee={'ABC','XYZ'}>}Days)

[dplr-rn]

for your reference and study
http://livingqlikview.com/livingqlik-roots-the-ultimate-qlikview-set-analysis-reference/

[Qliksenseranelx5]

DUH!!! The employees names are in all caps in the data model and i only had the first letters capital in the expression. Once i made the names all caps my chart populated with just the names i wanted.  Thanks so much for your help!!!!!

[dplr-rn]

thats weird.
whats the exact expression you put in.
also any other dimensions (other than employee)

[Qliksenseranelx5]

It Works!