topic Re: Error in Calculated Dimension ISSUE in QlikView

Error in Calculated Dimension ISSUE

Wed, 09 Jul 2014 05:47:59 GMT

i facing the problem with Error in Calculated Dimension when i use the formula with :

Wu + (Yu *Median(uETFintercept)) . Any one can tell me what's wrong with my formula?

Wed, 09 Jul 2014 06:14:59 GMT

Can u share a sample file

hic — Wed, 09 Jul 2014 06:16:41 GMT

Median() is an aggregation function. If you use an aggregation function in your calculated dimension, you need to have an Aggr() function around it.

But I don't understand what you are trying to do...

HIC

Wed, 09 Jul 2014 06:32:28 GMT

ya i think this is my prob....thk for fast reply....and i try it 1st......thk~~~~

Wed, 09 Jul 2014 06:35:56 GMT

but hw should i write on expression? Arg(Wu+Wv*Median(uETFintercept)) like this?? i try this but the software cant calculate for me......

Wed, 09 Jul 2014 06:39:46 GMT

when u use aggr() function, u should use like Aggr((Wu+Wv*Median(uETFintercept)),Dimension)

without dimension you cant use aggr() function.

Specify the dimension

Wed, 09 Jul 2014 06:46:35 GMT

Oh i see.....nw i can apply the refference line already but nothing happend on my scarret chart......u know wat the prob??

the below 2 picture is i want to do.......1st is my chart nw the 2nd is i draw by using paint.......pls help me thk~~~~~~