topic Re: Stacked Bar format Issue in QlikView

Stacked Bar format Issue

alec1982 — Fri, 07 Dec 2012 17:18:13 GMT

Hi Guys,

I have a stacked bar chart with two expression and I have the format of the nrs in the chart like Num(Sum(Sales),'$#.##0') on both of the expression.

Now the total nr that is showing on on the chart for both expression is not getting formatted. if I move the mouse over any of the stacked bar I see the foramts in the pop up text.

Any idea on how can I format the nr that is showing on data point for both of the expression?

Thxs,

Badr

Re: Stacked Bar format Issue

MayilVahanan — Fri, 07 Dec 2012 17:24:35 GMT

In number tab, check the expression default is assigned for both the expression

Hope it helps

Re: Stacked Bar format Issue

alec1982 — Fri, 07 Dec 2012 17:41:42 GMT

Hi Guys, thxs for the reply , I am limited on the number tab option. I cannot use it on this chart because the expression has toggle on it

it is like: if(Var1 ='1', Num(Sum(Sales)/ Sum(Total Sales),'#.##0%),Num(Sum(Sales),'$#.##0))

So basically I need to put the format in the expression. but it is not working for stacked bar chart

and It is Expression default on both of them

Re: Stacked Bar format Issue

MayilVahanan — Fri, 07 Dec 2012 17:47:49 GMT

Can you post a sample file?

if(Var1 ='1', Num(Sum(Sales)/ Sum(Total Sales),'#.##0%' ),Num(Sum(Sales),'$#.##0' ))

And one more doubt, in that expression you didn't close single quotes?

Re: Stacked Bar format Issue

alec1982 — Fri, 07 Dec 2012 18:44:00 GMT

I cannot post a sample, it is a huge qvw. also sorry I didnt close the single quote on the discussion only.