topic Error in calculated dimension in QlikView

Error in calculated dimension

Thu, 08 Mar 2012 16:03:09 GMT

Hi,

I have two tables one for sales and one for calls.

the key on both tables is the employee name.

I am trying to have a table chart that show Employee, Amount of Sales and Count(Number called).

I am getting an error in calculated dimension on Count(NumberCalled).

Any Idea on why I am getting the error.

thanks,

Error in calculated dimension

Thu, 08 Mar 2012 16:07:05 GMT

When you open the expression, at the top left of the screen does is say "Expression ok" ?

Try checking your field names, they are case and space sensitive

Error in calculated dimension

jonathandienst — Thu, 08 Mar 2012 16:10:19 GMT

Could you describe your data model, or better yet, post an the app or a sample of the app?

Regards

Jonathan

Error in calculated dimension

Thu, 08 Mar 2012 16:15:47 GMT

I guess, I have fixed it, I just added the employee and the amount as dimensions and the count (Numbercalled) as expression.

it looks like it is working fine however I have a date field which has the day date how can i make it to choose today's date as default.

Thanks,

Error in calculated dimension

Thu, 08 Mar 2012 16:29:27 GMT

try something like this:

count({$< Datefield = {"=$(=today())"}>} Numbercalled)

Error in calculated dimension

Thu, 08 Mar 2012 16:36:25 GMT

this didn't work.

it shows 0 on the count..field

Error in calculated dimension

jonathandienst — Thu, 08 Mar 2012 16:55:01 GMT

When date expressions like this dont work, its normally due to the date format being different. Set analysis is performed on the text value of the dates. Assuming that Datefield is in YYYYMMDD format, something like:

count({$< Datefield = {"$(=Date(today(), 'YYYYMMDD'))"}>} Numbercalled)

Adjust the format as appropriate.

Regards

Jonathan

Re: Error in calculated dimension

Thu, 08 Mar 2012 16:57:23 GMT

Hi,

My date field named DateField and the value in it is only for day like DD

I tried count({$< Datefield = {"$(=Date(today(), 'DD'))"}>} Numbercalled)

but I am still getting Zeros

how ever i have another Field that I can use wich is showing me the date of today like 40367

Error in calculated dimension

jonathandienst — Thu, 08 Mar 2012 17:02:57 GMT

So its a number. How about

count({< Datefield = {"$(#Day(today()))"} >} Numbercalled)

Check that the brackets are balanced

If that doesn't work, start from basics like

count({< Datefield = {1} >} Numbercalled)

count({< Datefield = {"$(#Day('2012/03/08'))"} >} Numbercalled)

etc

Jonathan

Re: Error in calculated dimension

Thu, 08 Mar 2012 17:04:46 GMT

I have changed the format of the DateField to YYYMMDD and I am still getting Zeros.

Re: Error in calculated dimension

Thu, 08 Mar 2012 17:25:44 GMT

I have adjusted the datefield to match YYYYMMDD and it seems to be fine.

Thanks you so much