topic Re: Use of Cyclic Group in Set Expression in QlikView

Use of Cyclic Group in Set Expression

mmainiero — Wed, 15 Feb 2017 13:54:16 GMT

Hi community,

I would like to use A Cyclic Group (name:Group) das an Dimension and reuse this Selection in a Set Expression.

Like:

Sum(counter) / sum( Total <Group> counter) this is actually working!

But i exprected something like that.

Sum(counter) / sum( Total {<GetSelectet(xxxx)}>} counter)

Can anybody explain what is the correkt syntax and how to use it?

Thank you all

Markus

sunny_talwar — Wed, 15 Feb 2017 13:57:09 GMT

Set expression or total qualifier? I am confused as to what you are looking for?

mmainiero — Wed, 15 Feb 2017 14:36:03 GMT

Hi,

I'm not sure what is here de different.

I will have the selection choosen in the cyclic group transfered or used into the formula.

Or the other way round - how can I use a formula dependent on the selected dimension.

Maybe these are two different things..

Regards,

Markus

sunny_talwar — Wed, 15 Feb 2017 16:29:56 GMT

May be (just may be) you need this:

Sum(counter)/Sum(Total <$(='[' & GetCurrentField([GroupName]) & ']'))> counter)

mmainiero — Thu, 16 Feb 2017 13:43:44 GMT

Looks good - I have to try it.

Tue, 13 Jun 2017 15:26:43 GMT

Nice trick....