topic Re: GROUP BY Pivot table in QlikView

GROUP BY Pivot table

MBV — Sat, 16 Nov 2024 01:05:44 GMT

Hey Guys,

I tried to calculate the Sum of Obligo and YTD.

The first table shows the sum of all transactions grouped by FP (Every FP contains several EKG). That worked fine.

The second table should show the sum grouped by the EKG but it is calculating the same as above for every EKG.

Why is it ignoring the EKG?

I'd be very grateful for your help!

Re: GROUP BY Pivot table

dplr-rn — Tue, 10 Mar 2020 15:08:30 GMT

from a quick look it looks as if the association between column EKG and rest seems to be the issue.

i would say check you data mode and put into a raw table and see what the output is

Re: GROUP BY Pivot table

Brett_Bleess — Tue, 07 Apr 2020 18:57:48 GMT

If Dilip's comment got you what you needed, be sure to close out your thread by returning to the post and using the Accept as Solution button on his post. I do agree with him, the only other thing of which I can think would be something in your Expression not being correct, which I did not see posted, so that makes it difficult for someone to be able to offer further help. We would really appreciate it if you can close things out or leave an update for us.

Regards,
Brett