6 Replies Latest reply: Jun 25, 2014 8:50 AM by Brett Nelson

# Here's Possibly an Easy Question??

I have three variables created and wish to use a chart with the variables as dimensions as a straight table don't want a pivot. As you can see the variables are doing the correct calculations but the names are adding "other".

Dimension expression below. I know '&' is not the correct operator but how can i get the name just showing 'Other' or 'Setup' or 'Run'

=(\$(vrrun))&(\$(vrsetup))&(\$(vrother))

variable \$(vrrun) expression is if( [description]= 'Running', 'Run', )

Any ideas??

Cheers

• ###### Re: Here's Possibly an Easy Question??

It looks like one of the variables value is Other which is being displayed in all the three variables.

What is the value of \$(vrother) ?

• ###### Re: Here's Possibly an Easy Question??

Hi Brett, can you post your QVW - it is a bit confusing what you are trying to achieve

• ###### Re: Here's Possibly an Easy Question??

Hi Brett,

You should define your \$vrother variable in the following way:

variable \$(vrother) expression is if( wildmatch([description],'Running','Setup')=0, 'Other', '')

Kind regards,

Andrei

• ###### Re: Here's Possibly an Easy Question??

Sorry was out yesterday couldn't reply out of office. QWV is massive, but below is variables.

Im now getting just setup time not setup plus Colo as per variable the coloum 1 expression should be over 3 hrs not 35mins 33secs. Chart looks like below.

Thanks Brett

• ###### Re: Here's Possibly an Easy Question??

Oh, You've got it  because you set wildmatch()=1.

That means [description] equal 1st expression in the list.

Just change it to >0

Hope this helps.

Andrei

• ###### Re: Here's Possibly an Easy Question??

Brilliant Thanks