set daily targets in a standard table graph

[chriscools]

Hello,

i made a standard table graph on store sales where the dimension is the day of the month (1,2,3,4,...)

the first column has as an expression the sum of the sales for that store.

in the second column i would like to show the daily target for the sales.

in the third column i then want to calculate the % of actual sales vs target.

i thought that i could do that by defining a variabele, called "daily sales target".

in the second column i then have an expression which includes the variable.

but it shows me nothing...

what am i doing wrong and what should i do to achieve this?

can someone help me with this?

thank you very much!

grtz,

chris

[#2]

just put ur target figure in 2nd expression, for eg. if daily target value is 1000, simply write 1000 in 2nd expr.

Regards

[chriscools]

that's what i first did, but then i thought that it should be easyli adaptable by the end user of this report.

and that's not someone who would be going into the details of the expressions to change this.

that's why i thought to do it like that...

is this not possible at all?

but in the meantime indeed i will do it like that!

grtz,

chris

[#4]

put the variable in an input box letting the user entering the daily target value & remove the column target from the chart.

if it doesn't help, post ur qvw.

[chriscools]

if i use the input box i still do not get to calculate my target %....

i'll post the qlikview file.

[MayilVahanan]

HI

Try like this

Sum({<Shop= {'Pomax Store Wijnegem'}, Year= {"2012"}>}LineSalesAmount) /[dagomzet wijnegem]

Hope it helps

[#7 · Accepted solution]

Solved.....

u were missing the brackets around the variable

[chriscools]

ok, thank you both for your help!!!

nice weekend!

grtz,

chris