topic Re: Error in calculated dimension in QlikView

Error in calculated dimension

Wed, 09 Jul 2014 06:06:24 GMT

Hi all,

I am newbie of QV software so i want to ask y my chart will shown to me with Error in calculated dimension?what's wrong with my problems?? sry for asking a noobie question....

Re: Error in calculated dimension

its_anandrjs — Wed, 09 Jul 2014 06:11:12 GMT

Please provide what error you get or any message without that no one can help if possible provide sample data.

Re: Error in calculated dimension

Wed, 09 Jul 2014 06:18:05 GMT

What expression you have in your calculated dimension.

There will some error in your expression

Re: Error in calculated dimension

pradnyat — Wed, 09 Jul 2014 06:23:28 GMT

Can you please share the expression you have written for calculated dimension?

Re: Error in calculated dimension

avinashelite — Wed, 09 Jul 2014 06:26:28 GMT

Hi Christopher,

Please post your application, so that we can trace the error.

Regards,

@vi

Re: Error in calculated dimension

Wed, 09 Jul 2014 06:30:33 GMT

i would like to do a calculation on my scatter to get a refference line which is Z=a+b*c

so i jz simply write on expression there with Z=a+b*c or i need to use a specific term to write my formula??

Re: Error in calculated dimension

Wed, 09 Jul 2014 06:33:21 GMT

write the expression in presentation tab--> Add reference

Re: Error in calculated dimension

amit_saini — Wed, 09 Jul 2014 06:38:17 GMT

Christopher,

Please see below how to add reference line, here below for label "Test" you can call your expression

Thanks,
AS

Re: Error in calculated dimension

avinashelite — Wed, 09 Jul 2014 06:40:46 GMT

To add the reference line add your expression as Vidhya Annamalai told.

Re: Error in calculated dimension

Wed, 09 Jul 2014 06:41:45 GMT

ya i know but i try to write my expression already but the software cant run it....maybe the way how i written the formula problem??

Re: Error in calculated dimension

Wed, 09 Jul 2014 06:43:55 GMT

The above is my work nw....i would like to add 1 line as the 2nd picture like that....the line i think can be done by using the refference line rite? but i could not to be add the reffernce line nw.....my formula is =A+B*C is just a simple formula but i not able to do it......

Re: Error in calculated dimension

amit_saini — Wed, 09 Jul 2014 06:44:08 GMT

write only = a+b*c instead of z= a+b*c

Thanks,
AS

Re: Error in calculated dimension

amit_saini — Wed, 09 Jul 2014 06:46:18 GMT

please share your application.

Thanks,

Re: Error in calculated dimension

Anonymous — Wed, 09 Jul 2014 06:48:16 GMT

Hi,

I really don't understand what causing you the issue. The best and quickest way to solve your issue is to provide some sample qvw or some real example.

Thanks

Re: Error in calculated dimension

Anonymous — Wed, 09 Jul 2014 06:51:27 GMT

Hi,

You may have to look into trendlines option available in chart expression tab.

Re: Error in calculated dimension

Wed, 09 Jul 2014 06:51:51 GMT

u can see the picture i post? my problem is i would like to get the second picture from the 1st picture nw. for my thinking is added 1 refference into my scatter chart but i donknow hw to add it. And the refference line should depand on the value from LINE = A + B*C.

Re: Error in calculated dimension

Wed, 09 Jul 2014 06:54:01 GMT

i donknow hw to attach the qvw file....can hlp me?sry....

Re: Error in calculated dimension

Wed, 09 Jul 2014 06:54:22 GMT

Share your sample file.

Re: Error in calculated dimension

Wed, 09 Jul 2014 07:01:17 GMT

Very thank satyadev....nw i able to add the line on my scatter chart already....but the trendlines only can with average,linear like that only? can i get the trendlines depand on my own formula???

Re: Error in calculated dimension

Wed, 09 Jul 2014 07:05:03 GMT

reply--> In the right top u can see Use advanced editor--> right bottom attach