multiple filters in qliksense expression for pivot table
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
Count of productid
but im getting this output, blue highlighted in classification JKL & MNO should not display