topic Re: Error in calculated dimension in QlikView

Error in calculated dimension

jmvilaplanap — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I have a mistery problem in a pivot table

The formulas are the same as the field names, and when I try to use "min(requesttime)" it throw an error. I think that the result of this dimension must to be at least the same of the previous column (later I will try to get the real min of each key)

Anyone can help me?

Thanks

Re: Error in calculated dimension

Anonymous — Thu, 06 Jul 2017 09:54:34 GMT

Hi Jose,

Try using =only(min(requesttime))

Thanks

Harshitha

Re: Error in calculated dimension

kaushiknsolanki — Thu, 06 Jul 2017 09:58:48 GMT

Hi,

Just try Minstring() see if the field is in text format or not?

Regards,

Kaushik Solanki

Re: Error in calculated dimension

jonathandienst — Thu, 06 Jul 2017 09:59:38 GMT

Perhaps something lile

=min(Aggr(requesttime, dim1, dim2, ...))

Where dim1, dim2, ... are the other dimensions for the pivot table.

Re: Error in calculated dimension

jmvilaplanap — Thu, 06 Jul 2017 10:03:34 GMT

Hi,

Is in num format, because I have used min(requesttime) in a label and it works.

Re: Error in calculated dimension

jmvilaplanap — Thu, 06 Jul 2017 10:04:26 GMT

Hi,

But I only want the min resquesttime, I don't need the other dimensions

Re: Error in calculated dimension

jonathandienst — Thu, 06 Jul 2017 10:09:23 GMT

The dimensions in the aggr() give the context for the minimum time. The context comes from the dimensions when the min() is a chart expression, but a calculated dimension does not get that same context.

Re: Error in calculated dimension

kaushiknsolanki — Thu, 06 Jul 2017 10:09:54 GMT

Hey you can not use the normal aggregation functions in dimension without the advanced aggregation function.

If you want to just get a minimum value then use it in expression instead of dimension.

To use in dimension you can try as below.

Aggr(Min(requesttime),Dim1)

Regards,

Kaushik Solanki

Re: Error in calculated dimension

jmvilaplanap — Thu, 06 Jul 2017 10:15:50 GMT

If I put this expresion "Aggr(min(requesttime),Dim1)" this will return an array, isn't it? I need only a one single value.

Re: Error in calculated dimension

jmvilaplanap — Thu, 06 Jul 2017 10:16:45 GMT

Is still don't working

I think, I need to find a workaround and try to do it in the script

Re: Error in calculated dimension

kaushiknsolanki — Thu, 06 Jul 2017 10:17:51 GMT

Hi,

It will give you Min for each dimension you specify in aggregation function.

If you need overall min then use it in expression like Min({1}requesttime)

Regards,

Kaushik Solanki

Re: Error in calculated dimension

jmvilaplanap — Thu, 06 Jul 2017 10:24:27 GMT

I need the min by each key, but this I can solve it with a TOTAL, I think. My problem now is to obtain a value in this dimension (probably will be the same value as in the previous column)

Re: Error in calculated dimension

Kushal_Chawda — Thu, 06 Jul 2017 10:29:15 GMT

your expression seems wrong

aggr(min(requesttime),Key)

Re: Error in calculated dimension

Kushal_Chawda — Thu, 06 Jul 2017 10:31:29 GMT

or use expression

=sum({<requesttime = {"$(=timestamp(min(requesttime),'DD/MM/YYYY hh:mm:ss'))"}>} Value)

Re: Error in calculated dimension

jmvilaplanap — Thu, 06 Jul 2017 10:35:17 GMT

Nope

Re: Error in calculated dimension

Kushal_Chawda — Thu, 06 Jul 2017 10:39:25 GMT

In aggr expression, use Key instead key, Field name is case sensitive

Re: Error in calculated dimension

jmvilaplanap — Thu, 06 Jul 2017 10:40:06 GMT

It works, but only for a one key (if the key is filtered)

But with this expression:

sum({<requesttime = {"$(=min(requesttime))"}>} 1)

Now I need to modify the expression to do it for each key.

Thanks

Re: Error in calculated dimension

jmvilaplanap — Thu, 06 Jul 2017 10:44:13 GMT

It works!

When you modify a lot of times the expression, finally you make mistakes.

Thanks!

Re: Error in calculated dimension

kaushiknsolanki — Thu, 06 Jul 2017 10:44:45 GMT

See the attached file it works.

Regards,

Kaushik Solanki

Re: Error in calculated dimension

Kushal_Chawda — Thu, 06 Jul 2017 10:44:52 GMT

You need to provide time format in your expression

try below

Assuming requesttime time format is DD/MM/YYYY hh:mm:ss

sum({<requesttime = {"$(=min(total <Key> requesttime),'DD/MM/YYYY hh:mm:ss'))"}>} 1)