Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pranubitla
Contributor II
Contributor II

Filter the balance based on group

 

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

 

1 Solution

Accepted Solutions
prma7799
Master III
Master III

10 Replies
sunny_talwar

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

pranubitla
Contributor II
Contributor II
Author

!

sunny_talwar

Don't know what that means

pranubitla
Contributor II
Contributor II
Author

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

pranubitla
Contributor II
Contributor II
Author

hi sunny can you see the attached sample app

prma7799
Master III
Master III

Untitled.png

pranubitla
Contributor II
Contributor II
Author

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

sunny_talwar

Like this?

Capture.PNG

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

prma7799
Master III
Master III

Like This ??