topic Re: Re: DIMENTION SET IN A CHART in QlikView

DIMENTION SET IN A CHART

adiarnon — Wed, 09 Oct 2013 06:36:07 GMT

i want to creat a chart that in the dimention it will get one of my fileds, lets say country, and i want to add one more value to the x axes of county that not excist in my table. for this new country i wiil calaulate the expression with an if statement in the expression.

how can i do that?

without changing the tables?

Re: DIMENTION SET IN A CHART

lironbaram — Wed, 09 Oct 2013 07:42:59 GMT

hi attach is an example

using dynamic update.

insert ab value to the input box , then press the button

the value will be added to the country field

in the chart the new value will get the average of all other countries.

Re: DIMENTION SET IN A CHART

adiarnon — Wed, 09 Oct 2013 08:22:15 GMT

tnx liron,

but if i want to add the value only for a specipic chart.

do i have any option to do that?

like in this chart,

i have a filed of year. in this chart only i want to add a bar of forecast (that not exist in the year filed)

and i calaulate the expression.

Re: DIMENTION SET IN A CHART

lironbaram — Wed, 09 Oct 2013 09:02:05 GMT

hi so you can

create a floating field let say yearForecast that will have all year values and forecast value added

then in the chart you can use if statements to calculate the results for example

sum(if(yearForecast=Year,Sales))

Re: DIMENTION SET IN A CHART

adiarnon — Wed, 09 Oct 2013 09:19:40 GMT

what do you mean by floating field?

i need to add the field to the sales table?

Re: Re: DIMENTION SET IN A CHART

lironbaram — Wed, 09 Oct 2013 11:56:02 GMT

no you create an island table with one field

have a look at the attach model

Re: Re: DIMENTION SET IN A CHART

adiarnon — Thu, 10 Oct 2013 07:18:47 GMT

tnx