Demensions and expressions

[#1]

I am creating a bar chart and I use the dimension dataservice_type

The dataservice_type dimension has 8 different catergories in itself. DB1 DBS1 DBS2 DBS3 DBS4 DBS5 M2M WSP1 and a nameless categorie.

I use expressions called CDR_DATA_IN_KB and BUNDLE_SIZE_IN_MB

i would like to limit the dataservice_type categories which are displayed to only the categories which have DB in the name. I thought this was done by, for instance, adding a set modifer like <dataservice_type={"DB*"}> to one of the expressions but this does not seem to work.

Displaying everythink works, but displaying a modified set does not, it stops to show the other expression no mather to which i add it. (both also doesnt work)

does somebody know how this should be done?

[#2]

try to create calculated dimension like: =if(left(dataservice_type,2)='DB',dataservice_type)

[#3 · Accepted solution]

BTW

your set modifier should work if you add it to all the expressions

[#4]

both doesn't work at all, it sais there is no data to display.

the calculated dimension also does not seem to work..

[#5]

for calculated dimension you need to check "Suppress when Value is Null"

[#6]

if you want to do it by expression, try this:

=sum({$<dataservice_type={"DB*"}>}CDR_DATA_IN_KB)

=sum({$<dataservice_type={"DB*"}>}BUNDLE_SIZE_IN_MB)

[#7]

thanks pari pari, but that is wat i did...

[#8]

so post a sample qvw file here