topic Re: Calculated dimension in QlikView

Calculated dimension

Mon, 24 Sep 2012 12:34:54 GMT

It is even possible to use the value of the Calculated dimension in expression

For example:

Calculated dimension- Aggr(Sum(Stock),Date)

Expression- Count(distinct if(Sum(Sales)>'Calculated dimension',Date))

Re: Calculated dimension

swuehl — Mon, 24 Sep 2012 12:40:24 GMT

You should be able to just use sum(Stock) instead of 'Calculated dimension' here. But since you embed an aggregation (sum()) into another aggregation function, you'll need to use advanced aggregation aggr() function here, too.

Or try:

=count({<Date = {"=sum(Sales)>sum(Stock)"}>} distinct Date)

Re: Calculated dimension

Mon, 24 Sep 2012 12:51:58 GMT

I do not care what happens in the expression and Calculated dimension, I'm interested in the possibility of using the value of the Calculated dimension In expression

Calculated dimension=2

Expression= if(Calculated dimension=2,"two",null())

Re: Calculated dimension

swuehl — Mon, 24 Sep 2012 12:56:35 GMT

And replacing your 'Calculated dimension' with the expression you are using in the aggr() function should / could work fine.

edit:

Ok, this only works if you only get one distinct underlying dimension value, back (i.e. Date in your sample). In general, you need to repeat the complete calculated dimension.

Re: Calculated dimension

Mon, 24 Sep 2012 12:58:37 GMT

I can not

formula will work correctly only in Calculated dimension

Re: Calculated dimension

swuehl — Mon, 24 Sep 2012 13:01:01 GMT

Could you post a small sample app? Or your complete dimension and expression definitions?

Re: Calculated dimension

Mon, 24 Sep 2012 13:03:47 GMT

i can not

Re: Calculated dimension

Mon, 24 Sep 2012 13:07:52 GMT

I am interested in only one thing, is it possible to get the value of the Calculated dimension in expression

Re: Calculated dimension

swuehl — Mon, 24 Sep 2012 13:15:43 GMT

If you have a calculated dimension like

=Aggr(Sum(Stock),Date)

an expression like

=Aggr(Sum(Stock),Date)

returns the dimension value. There is no function to "call" the calculated dimension value directly, AFAIR (edit: sorry, for the acronym, http://en.wiktionary.org/wiki/AFAIR).

Re: Calculated dimension

Mon, 24 Sep 2012 13:23:43 GMT

not understood.

what is it afair?

Re: Calculated dimension

Mon, 24 Sep 2012 13:35:55 GMT

it's a pity

But thanks for that