topic Re: Change Dimension in QlikView

Change Dimension

rodri_morales — Wed, 11 Sep 2013 14:34:11 GMT

I have a doubt, can I use a Combo Box to change de dimension of a bar chart? Can anyone explain me how to do it?

Re: Change Dimension

stigchel — Wed, 11 Sep 2013 14:51:24 GMT

Sure, load the exact names of the dimension fields into a new field e.g. "Dimension", add that field to the combo box and in the dimension of the bar chart put [$(=Dimension)]

Also a good idea to set the always one selected value option for the field "Dimension"

Re: Change Dimension

stigchel — Wed, 11 Sep 2013 14:56:27 GMT

Also if you need other labels than the field names use an extra field e.g. "DimLabel" Example:

load * inline [Dimension,DimLabel

Field1, Label1

Field2, Label2

....

];

Re: Change Dimension

rodri_morales — Wed, 11 Sep 2013 15:04:24 GMT

The dimension are calculated, eg: EsCanje=0 or EsCanje=1... it's posible to do it? Where is the typ Combo Box?

Re: Change Dimension

stigchel — Wed, 11 Sep 2013 16:25:31 GMT

You probably want a MultiBox with one field and yes you can also put an expression in the "Dimension" field and use DimLabel to put in this MultiBox to let the user choose the calculated dimension.

Re: Change Dimension

rodri_morales — Thu, 12 Sep 2013 13:24:30 GMT

Sorry, I cant understand you.. I try to explain my problem:

I have 2 charts: Area Problema (dimension: AreaName, show the amount of problems for each area) and Type Problema (dimension: ProblemName, show the amount of problem for each type). I want to do a ComboBox so I can select "Area" or "Type" and the chart change.

Can you explain me how to load it?

Re: Change Dimension

Thu, 12 Sep 2013 14:03:49 GMT

Hi,

You can use input box as a combo box

right click in the sheet->New Sheet Object->Input box-> Add the variable->Go to Constraints->Select predefined values only->Give the list of values as Area;Type;->Use this variable in your chart dimension and in expression add the conditional that to show the chart

If you can't achive this pls post your sample file

Re: Change Dimension

stigchel — Thu, 12 Sep 2013 14:15:57 GMT

- In your script:

load * inline [Dimension,DimLabel

AreaName, Area

ProblemName, Type

];

- Reload

- Make a new sheet object-->MultiBox --->Add field DimLabel

- Now choose between two options:

1 Two graphs, on the layout tab mark show conditional and put DimLabel='Area' for the area chart on the other DimLabel='Type'

2 One graph, in the dimension put [$(=Dimension)]

-Now when you select a value in the MultiBox the correct chart will show

Re: Change Dimension

rodri_morales — Fri, 13 Sep 2013 12:36:38 GMT

When I add:

LOAD * inline [Dimension,DimLabel

AreaName, Area

ProblemName, Type

];

the script show me a problema with AreaName.. AreaName and ProblemName are load first.. how I explain you.. I load different values, then I try to add the declaration you told me, but when I do it, it show me an error

Here is the part of the script:

LOAD DetalleProblema,

RazonSocial_Empresa,

DetalleArea,

Operacion,

Estado,

UsuarioResolvio,

FechaResolucion,

* inline [Dimension, DimLabel

DetalleProblema, TipoProblema

RazonSocial_Empresa, Empresa];

Re: Change Dimension

matthieu_burel — Fri, 13 Sep 2013 12:39:52 GMT

You can do it as explain before...

Why not using a cyclic group ?

Re: Change Dimension

rodri_morales — Fri, 13 Sep 2013 12:59:45 GMT

I create the Input Box and do what you said.. but when you say "Use this variable in your chart dimension..", what variable are you talking?

Re: Change Dimension

stigchel — Fri, 13 Sep 2013 13:01:30 GMT

I have no idea what you are trying to do, all I can see is you have included my suggested script within an other load script, it should be a separate load.

Either upload a sample of your document, or I'm unable to help you any further...

Re: Change Dimension

rodri_morales — Fri, 13 Sep 2013 13:13:04 GMT

Here are images:

Re: Change Dimension

stigchel — Fri, 13 Sep 2013 13:22:17 GMT

From what I can see in the picture this piece of script is placed after a preceding load?? Place the inline load before the previous load statement.

Re: Re: Change Dimension

stigchel — Fri, 13 Sep 2013 13:36:50 GMT

See my attached example of what I mean

Re: Change Dimension

rodri_morales — Fri, 13 Sep 2013 14:11:00 GMT

It works correctly Piet, than you for your time! I appreciate... Another doubt, the chart start with no value, when I click on one, the chart work correctly. Can I put a default value, so the chart start showing Problem or Area?

Re: Change Dimension

stigchel — Fri, 13 Sep 2013 14:20:51 GMT

Yes you can, as suggested earlier, mark the "Always one selected" option for this field:

- Put a listbox on your sheet with the DimLabel field

- Select one value in this listbox

- In properties\general tab of this listbox mark always one selected

After you have done this you can remove the listbox, it is a field setting, so qv will 'remember' this option

I've also done this in the sample.qvw I attached earlier (just add the listbox DimLabel to see)

Re: Change Dimension

rodri_morales — Fri, 13 Sep 2013 15:43:10 GMT

Can I apply the same to a calculate expresion? I want to:

sum(if(EsCanje=0, amount))

sum(if(EsCanje=1, amount))

I try to do it, but I dont know how to write the calculate expresion.

Re: Change Dimension

stigchel — Mon, 16 Sep 2013 08:42:13 GMT

The syntax is correct for an expression (provided that EsCanje and amount are correct field names (including caption)).

However, EsCanje should either always have one value or should be part of the dimensions.

If you add EsCanje to the dimensions, you do not need the if--> sum(amount) is enough

Otherwise use an aggegrate --> Aggr(sum(if(EsCanje=0,amount)),EsCanje)