Here's Possibly an Easy Question??

[bnelson111]

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

[sudeepkm]

can you please post your QVW?

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) ?

[Anonymous]

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

[crusader_]

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

[bnelson111]

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

[crusader_ · Accepted solution]

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

[bnelson111]

Brilliant Thanks