Filtering data according to a group

Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

While developing a Pivot table , I need to filter my data according to a Group. The Group dimension is classified in several markets(another dimension). The table is having data as below :

Group	Market	Sales	Budget
Group	A	10	-
	B	20	-
	C	30	-
	D	40	-
Non-Group	A	20	-
	B	30	-
	C	50	-
	D	40	-
Total		240

When I add budget here, I get either zero or null values. Basically the budget is not getting classified according to the Group Dimension. How to filter budget (measure) according to the Group category?

Any help would be appreciated.

Re: Filtering data according to a group

sunny_talwar — Fri, 16 Jun 2017 15:47:00 GMT

Would you be able to share a sample to show the issue?

topic Re: Filtering data according to a group in QlikView

Filtering data according to a group

Re: Filtering data according to a group