Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in Calculated Dimension ISSUE

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?


6 Replies
Not applicable
Author

Can u share a sample file

hic
Former Employee
Former Employee

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

1.pngOh 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~~~~~~

2.png