Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Calulated Dimension - aggr giving me "-"

I have the following calculated dimension for a graph:

=aggr(only({<Year={'2014','2015'}>}Year),Year)

The problem is it give me a bar chart with 2014, 2015 but also with a bar that has " - " as a year. How can I write this so it is only 2014 and 2015 and gets rid of that extra null bar.

Thanks,

Zag

1 Solution

Accepted Solutions
Kushal_Chawda

for this calculated dimension check the Option "suppress when value is NULL"

View solution in original post

4 Replies
Kushal_Chawda

for this calculated dimension check the Option "suppress when value is NULL"

zagzebski
Creator
Creator
Author

Thanks. But still wondering when I set on 2014, 2015 why I would get a null "-" value also.

Not applicable

if you are applying individual check out the same Option "suppress when value is NULL" as said by Kush141087 or check the Raw DATA

Kushal_Chawda

Yes, you have set the values by 2014 & 2015, but it will work only in expression. Because expression evaluates first.