topic Re: How to get current selection of the alternate state? in QlikView

How to get current selection of the alternate state?

Mon, 10 Jun 2013 05:52:32 GMT

Hi,

I have 2 alternate states (Main and sub). How do i get the current field selection of the state in my expression?

Basically i have 2 sheets and I do not want the field selected interfere with each other.

Sum( { [Sub] <[Count A] = $::[Count A]>} [Budget Value] )

I wan to achieve something like

Sum( { [Sub] <[Count A] = [Main][Count A]?>} [Budget Value] )

Mon, 10 Jun 2013 08:25:33 GMT

I manage to figure out as the following.

Sum( { [Sub] <[Count A] = { $( = Concat({Main} DISTINCT Chr(39)&[Count A]&Chr(39), ',' ) ) } > } [Budget Value] )

It works but not sure it is the correct way of doing.

swuehl — Mon, 10 Jun 2013 08:40:45 GMT

Have you tried using the scope operator here, too:

Sum( { [Sub] <[Count A] = Main::[Count A] > } [Budget Value] )

Sum( { [Sub] <[Count A] = p(Main::[Count A]) > } [Budget Value] )

Mon, 10 Jun 2013 08:56:24 GMT

whao. thanks buddy.

I use the scope operator and it works.

Sum( { [Sub] <[Count A] = Main::[Count A] > } [Budget Value] )

Wed, 26 Nov 2014 07:31:18 GMT

Can you share the sample qvw solution?