topic Re: Here's Possibly an Easy Question?? in QlikView

Here's Possibly an Easy Question??

bnelson111 — Tue, 24 Jun 2014 13:46:33 GMT

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

sudeepkm — Tue, 24 Jun 2014 13:52:56 GMT

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

Re: Here's Possibly an Easy Question??

Anonymous — Tue, 24 Jun 2014 13:53:33 GMT

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

crusader_ — Tue, 24 Jun 2014 14:55:31 GMT

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

bnelson111 — Wed, 25 Jun 2014 09:45:40 GMT

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

crusader_ — Wed, 25 Jun 2014 11:56:16 GMT

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

bnelson111 — Wed, 25 Jun 2014 12:50:00 GMT

Brilliant Thanks