Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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) ?
Hi Brett, can you post your QVW - it is a bit confusing what you are trying to achieve
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
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
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
Brilliant Thanks