topic Re: Dimansionality () issue in QlikView

Dimansionality () issue

Tue, 27 Sep 2016 11:32:50 GMT

Hi,

Need to realise tree structure in Pivot table, where Price is not summed on diffirent levels.

It works when i use such expression, but actually there are more levels.

if (

Dimensionality()=1, only({<NodeDepth={1}>}Price),

if(Dimensionality()=2, only({<NodeDepth={2}>}Price),

if(Dimensionality()=3, only({<NodeDepth={3}>}Price),

if(Dimensionality()=4, only({<NodeDepth={4}>}Price)

))))

Try to use Pick () Match(), but it doesn't work with Dimansinality()

= only({<NodeDepth={"$(=pick(Match(Dimensionality(),1,2,3,4)1,2,3,4))"}>}Price)

Pls let me know if you have any ideas

Thanks

sunny_talwar — Tue, 27 Sep 2016 16:27:42 GMT

How about this?

=Pick(Dimensionality(),

Only({<NodeDepth={1}>}Price),

Only({<NodeDepth={2}>}Price),

Only({<NodeDepth={3}>}Price),

Only({<NodeDepth={4}>}Price))

Wed, 28 Sep 2016 07:14:16 GMT

Thanks, it also works, but need simplified expression.

sunny_talwar — Wed, 28 Sep 2016 17:26:21 GMT

Not sure if it can be simplified any further, but I will wait to see if someone has a better advice. May be marcowedel‌

Best,

Sunny

MarcoWedel — Wed, 28 Sep 2016 21:53:49 GMT

Hi,

one solution without hard coded NodeDepth or dimensionality values in the expression might be:

-(Dimensionality()=Min(NodeDepth))*FirstSortedValue(Price,NodeDepth)

hope this helps

regards

Marco