topic Demensions and expressions in QlikView

Demensions and expressions

Fri, 10 Aug 2012 11:45:12 GMT

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?

Re: Demensions and expressions

Fri, 10 Aug 2012 11:47:29 GMT

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

Re: Demensions and expressions

Fri, 10 Aug 2012 11:49:43 GMT

BTW

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

Re: Demensions and expressions

Fri, 10 Aug 2012 12:17:17 GMT

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

the calculated dimension also does not seem to work..

Re: Demensions and expressions

Fri, 10 Aug 2012 12:25:10 GMT

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

Re: Demensions and expressions

Fri, 10 Aug 2012 12:27:59 GMT

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)

Re: Demensions and expressions

Fri, 10 Aug 2012 12:29:18 GMT

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

Re: Demensions and expressions

Fri, 10 Aug 2012 12:31:25 GMT

so post a sample qvw file here