topic Re: Filter the balance based on group in QlikView

Filter the balance based on group

pranubitla — Fri, 02 Jun 2017 11:05:23 GMT

The below straight table shows the dimension is period (12 months) and expression is balance.

Now want to add a Group field as well

Group filed has two groups which is Group A and group B so the balance filtered in to Group A balance and Group B balance on month wise.

the resulting table would be

Period

Group A balance

Group B balance

total balance

please help to filter the balance by group

sunny_talwar — Fri, 02 Jun 2017 11:07:16 GMT

Would you be able to share a sample qvw to look at the issue?

pranubitla — Fri, 02 Jun 2017 11:19:36 GMT

sunny_talwar — Fri, 02 Jun 2017 11:20:30 GMT

Don't know what that means

pranubitla — Fri, 02 Jun 2017 11:21:48 GMT

Hi sunny please let me know how to attach the sample qvw application

pranubitla — Fri, 02 Jun 2017 11:23:17 GMT

hi sunny can you see the attached sample app

prma7799 — Fri, 02 Jun 2017 11:24:02 GMT

pranubitla — Fri, 02 Jun 2017 11:30:10 GMT

please see I've attached the sample application on the above thread

sunny_talwar — Fri, 02 Jun 2017 11:30:17 GMT

Like this?

Created a pivot table with Group as one of the dimensions and then added subtotal for Group field from the presentation tab

prma7799 — Fri, 02 Jun 2017 11:30:25 GMT

Like This ??

pranubitla — Fri, 02 Jun 2017 11:43:34 GMT

is that simple. thanks for this