topic Re: Create variable in QlikView

Create variable

Anonymous — Thu, 23 Aug 2012 18:21:26 GMT

Hi,

I want to create dynamic variable which get current selection.

Than I want to use this variable in condition.

For example, if current selection = A, show green color, else gray.

=if(FieldName = My selection), rgb(139,191,31), rgb(124,124,124))

Thanks,

Re: Create variable

chematos — Thu, 23 Aug 2012 20:27:48 GMT

if(GetCurrentSelection(FieldName ) = A, rgb(139,191,31), rgb(124,124,124))

Re: Create variable

Anonymous — Thu, 23 Aug 2012 20:32:30 GMT

Hi Jose,

It should be dynamic selection.

It works well with replace bookmarks.

=if(Industries = only({BM03} Industries), rgb(139,191,31), rgb(124,124,124))

When I published it on web server, my bookmarks didn't work.

That's why I need to create dynamic variable.

Thanks,

Re: Create variable

chematos — Thu, 23 Aug 2012 20:44:22 GMT

well, create an entry box and use New Variable option and use this as the value:

=GetFieldSelections(FieldName)

=if(Industries =$(vVariable), rgb(139,191,31), rgb(124,124,124))

Re: Create variable

Anonymous — Fri, 24 Aug 2012 13:57:43 GMT

It doesn't work. I attached an example.

Re: Create variable

chematos — Fri, 24 Aug 2012 14:19:19 GMT

Take a look on this.

Is something like this or I´m missunderstanding?

Re: Create variable

chematos — Fri, 24 Aug 2012 14:20:21 GMT

I haven´t modified the expressions but you could use the variables

Re: Create variable

Anonymous — Fri, 24 Aug 2012 15:41:49 GMT

I have problem this expression.

I can't create right condition.

I create variable =GetFieldSelections(FieldName).

Cheers,

Re: Create variable

chematos — Fri, 24 Aug 2012 18:14:22 GMT

what's the problem exactly?

with this expression?

=if(Industries = $(vIndustry) ,rgb(139,191,31), rgb(124,124,124))

Re: Create variable

Anonymous — Fri, 24 Aug 2012 18:22:59 GMT

Yes, It doesn't reconize Industries.

I select from Industries =A.

My vIndustry shows Industries:A

And condition doesn't work. I think it should be like

=If( Industry (selected A)=$(vIndustry) (Industries:A), rgb(...)

It should compare apple to apple.

If I select indusry A, the vIndustry should be only A. In this case my expression works.

I hope you understand me.

Thanks,

Re: Create variable

chematos — Fri, 24 Aug 2012 18:31:48 GMT

try with '$(vIndustry)'

Re: Create variable

Anonymous — Fri, 24 Aug 2012 18:38:34 GMT

Yes, I played around, but didn't work.

Cool!!! Thanks,

Re: Create variable

Anonymous — Fri, 24 Aug 2012 18:49:27 GMT

No, didn't work.

I was confused with my chart, where I use Bookmark.

Re: Create variable

Anonymous — Fri, 24 Aug 2012 19:04:58 GMT

It should be very easy issue.

I use it =if(Client = only(Client), rgb(139,191,31), rgb(124,124,124))

it shows all client green, but I selected just one.

Re: Create variable

chematos — Fri, 24 Aug 2012 19:09:51 GMT

Try with these options:

if(Client = match(Client,'$(vClient)'), ...)

if(Client = match(Client,$(vClient)), ...)

if(Client = concat('$(vClient)'), ...)

if(Client = concat($(vClient)), ...)

I don´t know why is not working with the variable....

Re: Create variable

Anonymous — Fri, 24 Aug 2012 19:19:11 GMT

Please see my attached picture.

It's text box, which show me my current selection. I think I need separate it.

Re: Create variable

chematos — Fri, 24 Aug 2012 19:30:02 GMT

=getCurrentSelections()

see de attached file

Re: Create variable

Anonymous — Fri, 24 Aug 2012 19:47:35 GMT

I tried it.

It didn't match with Client, because it compares Client wit Variable=

Client: toolbarn.com

Industries: Construction

Re: Create variable

Anonymous — Fri, 24 Aug 2012 19:58:43 GMT

I created like you offered 2 variable (=GetFieldSelections(Industries) and =GetFieldSelections(Client))

Re: Create variable

Anonymous — Fri, 24 Aug 2012 20:00:22 GMT

Maybe because I use Alternate State.

I have 2 multibox.