applying multiple filters in qliksense pivot table based on dimenions

[su88rao]

Spoiler

Spoiler

Hi ,

I have filtered the product_id >=5 based on brands n this is working fine. I have one more column called classification and want it to be filtered on that column as well

for eg: I have product_id count as 8 for same brands but its for different classification. When i do the pivot in qliksense for one classification its showing proper count of product_id as it has more thn 5 but  same condition does not applies for other classification. because brand name is same, so the count of tht particular classification & brand is showing which is less then 5 .

I have tried few thngs but its not working out. can you help me out here. let me know if you need any further info on this

this is the output i need

classification	brand	Count of productid
ABC	Total	10
JSDJS	5
DJDJD	5
DEF	Total	5
TDYDU	5
GHI	Total	23
FDSDDS	7
DKNDKO	6
UISIOA	5
MAJKN	5
JKL	Total	22
YAYUA	5
LJSJJD	17
Grand Total		60

but im getting this output, blue highlighted in classification JKL & MNO should not display 

classification	brand	Count of productid
ABC	Total	10
JSDJS	5
DJDJD	5
DEF	Total	5
TDYDU	5
GHI	Total	23
FDSDDS	7
DKNDKO	6
YAYUA	5
MAJKN	5
JKL	Total	24
KQDMNF	5
LJSJJD	17
YAYUA	2
MNO	Total	1
YAYUA	1
Grand Total		63

my expression looks like this now,

Count({<Year = {$(=Max(Year))}, Weeknum = {$(=Max(Weeknum))}, Brand = {"=Count({<Year = {$(=Max(Year))}, Weeknum = {$(=Max(Weeknum))}>} product_id) >= 5"}>} product_id)

[su88rao · Accepted solution]

i got the solution for this.

i concatenated 2 fields and used the concatenated field as my dimension to get the values.which worked fine.

concat is done in script .

classification & ' - ' & product_id as pro_class

used this column in dimension with the same above mentioned expression and it worked