multiple filters in qliksense expression for pivot table

su88rao — Mon, 20 Dec 2021 21:38:40 GMT

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)

topic multiple filters in qliksense expression for pivot table in App Development

multiple filters in qliksense expression for pivot table