Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
BTW
your set modifier should work if you add it to all the expressions
try to create calculated dimension like: =if(left(dataservice_type,2)='DB',dataservice_type)
BTW
your set modifier should work if you add it to all the expressions
both doesn't work at all, it sais there is no data to display.
the calculated dimension also does not seem to work..
for calculated dimension you need to check "Suppress when Value is Null"
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)
thanks pari pari, but that is wat i did...
so post a sample qvw file here