topic Getting wrong result in Straight table in QlikView

Getting wrong result in Straight table

bhupesh_gupta — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have one scenario which I am not able to implement.

Data is some thing like this

So here a policy can have multiple Group and amount divided between them.

Now if a user selects one group in a list box let's say 112, resultant table should show some thing like this

But I am getting this

Policy	Group	sum(Amount)	=sum({<Policy=p(Policy),Group=>}Amount)
		14000	21750
100	111	0	5000
100	112	5000	5000
200	111	0	2750
200	112	3000	3000
300	112	6000	6000

Can some one help me on this.

I have attached the sample app as well.

Regards

Bhupesh

rubenmarin — Wed, 23 Nov 2016 11:12:05 GMT

Hi Bupesh, maybe with:

=If(not IsNull(Group), sum(TOTAL <Policy> {<Policy=p(Policy),Group>}Amount))

If(not IsNull(Group) --> To show only rows of the selected groups.

TOTAL <Policy> --> To sum all groups amount of the same policy

lironbaram — Wed, 23 Nov 2016 11:15:48 GMT

have a look at the attachment

bhupesh_gupta — Wed, 23 Nov 2016 11:25:38 GMT

Hi Liron

Thanks your option works as well

Regards

Bhupesh

bhupesh_gupta — Wed, 23 Nov 2016 11:26:00 GMT

HI Ruben

Thanks it worked.

Regards

Bhupesh

rubenmarin — Wed, 23 Nov 2016 11:34:29 GMT

Glad to help.

The "Policy=p(Policy)" is not needed, as the selections will do that, so:

=If(not IsNull(Group), sum(TOTAL <Policy> {<Group>}Amount))