topic Re: Re: Re: Re: Dynamic system fields in radar chart in QlikView

Dynamic system fields in radar chart

Fri, 11 Jul 2014 10:44:43 GMT

Hello.

I want to create radar chart where I will be able to change expression using system table "$Field".

So I've created Listbox with system fields. Then I've created Variable vFieldSelection "='['&[$Field]&']'".

And now I've created expression in chart like that "Sum ($(vFieldSelection))".

And everything is fine when I want to show only 1 expression from 1 selected field.

But when I select more then 1, there is no data.

I want to create more expressions for chart using next selected items.

Is there any way to get first selected field to variable, then second selected item to variable etc. so I will be able to add more expressions for next variables?

Re: Dynamic system fields in radar chart

ali_hijazi — Fri, 11 Jul 2014 10:53:48 GMT

use the getSelectedCount(field) to know how many values selected

and use concat function to display selected values

concat(Distinct field , ',')

Re: Dynamic system fields in radar chart

tresB — Fri, 11 Jul 2014 11:00:07 GMT

You can use GetFieldSelections() with a separator like:

vAllFields=GetFieldSelections([$Field] , ';')

this will generate a string like: 'Field1;Field2;Fiel3' .

Then separate the sting out using SubField() like:

vField1=SubField('$(vAllFields)' , ';' ,1)

vField2=SubField('$(vAllFields)' , ';' ,2)

vField3=SubField('$(vAllFields)' , ';' ,3)

Re: Dynamic system fields in radar chart

rbecher — Fri, 11 Jul 2014 11:29:17 GMT

Hi Maciej,

I have done a similar chart with this:

Dimension:

$Field

Expression1:

$(=concat('if($Field=' & chr(39) & $Field & chr(39) & ',sum([' & $Field & '])', ',') & concat(right($Field&')',1)))

Expression2:

$(=concat('if($Field=' & chr(39) & $Field & chr(39) & ',count([' & $Field & '])', ',') & concat(right($Field&')',1)))

However, this shows all fields if no selection is made.

- Ralf

Re: Dynamic system fields in radar chart

Fri, 11 Jul 2014 11:39:55 GMT

Hi, when I put directly function GetFieldSelections([$Field] , ';') to textbox expression, I get nice list with field names.

But when I set it to variable, then I get information: Error: Garbage after expression: "asd". I assume that's why I have space in names. How can I pass that?

EDIT: Ok it was garbage expression, because I've tried to see this in textbox like that "=$(vAllFields)", but when I've typied "=vAllFields" I got correct value.

But now functions for vField1 and other are not working. I've tried "Sum($(vField1))" and Sum(vField1) and it doesn't work 😞

Re: Dynamic system fields in radar chart

Fri, 11 Jul 2014 12:21:40 GMT

Hi Ralf,

Thanks, but it also only works when I have 1 selection.

Re: Dynamic system fields in radar chart

rbecher — Fri, 11 Jul 2014 12:25:45 GMT

Works on my site with a listbox on $Field...

Re: Dynamic system fields in radar chart

tresB — Fri, 11 Jul 2014 12:28:45 GMT

Try :

=$(='Sum('&'$(vField1)' &')' )

Or,

=$(='Sum('&'$(=vField1)' &')' )

Re: Dynamic system fields in radar chart

Fri, 11 Jul 2014 12:52:52 GMT

Fields var:

vAllFields =GetFieldSelections([$Field],',')

I've tried for vField1

=SubField('$vAllFields', ';' ,1)

=SubField($vAllFields, ';' ,1)

=SubField('vAllFields', ';' ,1)

=SubField(vAllFields, ';' ,1)

=SubField($(vAllFields), ';' ,1)

And both expressions doesn't work 😞

Re: Dynamic system fields in radar chart

tresB — Fri, 11 Jul 2014 12:56:46 GMT

Why don't you post a qvw with sample data? I guess, it's just a variable expansion issue.

Re: Re: Dynamic system fields in radar chart

Fri, 11 Jul 2014 13:27:18 GMT

Ok, you're right it will be easier. Here it is.

Re: Re: Re: Dynamic system fields in radar chart

rbecher — Fri, 11 Jul 2014 13:43:34 GMT

Here we go..

Re: Re: Re: Dynamic system fields in radar chart

Fri, 11 Jul 2014 13:47:56 GMT

Thank you. I've must made some mispelling or somethin.Or I had different value in dimension and that's why I had errors.

But still I'm curious tresesco solution.

Re: Re: Re: Dynamic system fields in radar chart

rbecher — Fri, 11 Jul 2014 13:49:41 GMT

You should set a condition to view the chart only if something (and not too much) is selected from $Field...

Re: Re: Re: Re: Dynamic system fields in radar chart

tresB — Sat, 12 Jul 2014 06:07:27 GMT

The vField1 definition was missing a pair of parenthesis.

vField1=SubField('$(vAllFields)', ';' ,1) // and it works fine.

PFA

Re: Re: Re: Re: Re: Dynamic system fields in radar chart

Mon, 14 Jul 2014 07:23:14 GMT

Hi thank you. It's working, but I have spaces in tags, and then it doesn't work 😞

Any solution maybe?

Re: Re: Re: Re: Dynamic system fields in radar chart

tresB — Mon, 14 Jul 2014 07:35:28 GMT

Put '[ ]' in the variable definition like:

='['&SubField('$(vAllFields)', ';' ,1)&']'

Re: Re: Re: Re: Dynamic system fields in radar chart

Mon, 14 Jul 2014 07:52:12 GMT

Thanks. It works, but still only for 1 selection, when I select 2 vals, it has no data ;-).