topic Re: use dimensionality() in set analysis in QlikView

use dimensionality() in set analysis

kristof_j — Thu, 08 Mar 2018 17:24:28 GMT

is it possible to use the dimensionality() function in a set analysis? And how?

something like

sum( {<level = { $(=dimensionality()) }>} sales)

but this doesn't seem to work.

Re: use dimensionality() in set analysis

kristof_j — Thu, 08 Mar 2018 17:25:47 GMT

So the dimensionality() could be different on each row of the pivot table.

Re: use dimensionality() in set analysis

isingh30 — Thu, 08 Mar 2018 17:57:09 GMT

It's not an ideal thing. What's your requirement?

Re: use dimensionality() in set analysis

big_dreams — Thu, 08 Mar 2018 18:35:19 GMT

what are you trying to achieve??

Re: use dimensionality() in set analysis

kristof_j — Fri, 09 Mar 2018 08:52:16 GMT

Idd it's not ideal. But is it possible?

It is nice to know, regardless of what I want to achieve with it.

I'm going to post the real question but I'm not going to mention this post

I want to see your creative minds

Re: use dimensionality() in set analysis

annapochyla — Fri, 09 Mar 2018 09:43:14 GMT

Hi,

Sets in set analysis are created 'independent' of the table they are used in.

that is why you cannot use for example dimension values in set analysis.

And that could be the reason, why you cannot use dimensionality() in set analysis.

Re: use dimensionality() in set analysis

sunny_talwar — Fri, 09 Mar 2018 12:34:04 GMT

AFAIK, I don't think this would be possible to do

Re: use dimensionality() in set analysis

big_dreams — Fri, 09 Mar 2018 16:44:40 GMT

hmm actually it is interesting,

You can not use ddimensionality() in set analysis but you can use it in if else statement.

Regards,

Edit : forgot to type not.

Re: use dimensionality() in set analysis

Colin-Albert — Fri, 09 Mar 2018 17:47:06 GMT

Hi Kristof,

It is not possible to use dimensionality() in your set expression.

This is because the set is evaluated for the chart data as a whole and is not evaluated row-by-row.

Dimensionality is row dependent so cannot be used in the set expression.

You can use dimensionality in an "if" statement.

for example if(dimensionality() > 2, sum(sales))

This post on Dimensionality may help How to use - Dimensionality()

Re: use dimensionality() in set analysis

MarcoWedel — Fri, 09 Mar 2018 22:29:26 GMT

please post some sample data and your expected result.

Re: use dimensionality() in set analysis

swuehl — Fri, 09 Mar 2018 22:37:37 GMT

It won't work as you expected since the dollar sign expansion $(=dimensionality()) will be performed even before the expression will be parsed and evaluated. So it has in fact nothing to do with the abilities of set analysis (though it's true that set analysis does not consider chart dimensions, but is evaluated once).