Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

DIMENTION SET IN A CHART

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?

6 Replies
lironbaram
Partner
Partner

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.

adiarnon
Creator III
Creator III
Author

tnx liron,

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

do i have any option to do that?

Capture.PNG.png

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.

lironbaram
Partner
Partner

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

adiarnon
Creator III
Creator III
Author

what do you mean by floating field?

i need to add the field to the sales table?

lironbaram
Partner
Partner

no you create an island table with one field

have a look at the attach model

adiarnon
Creator III
Creator III
Author

tnx