applying multiple filters in qliksense pivot table based on dimenions

su88rao — Sat, 16 Nov 2024 05:21:38 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)

Re: applying multiple filters in qliksense pivot table based on dimenions

su88rao — Tue, 09 Jul 2019 08:20:18 GMT

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

topic applying multiple filters in qliksense pivot table based on dimenions in App Development

applying multiple filters in qliksense pivot table based on dimenions

Re: applying multiple filters in qliksense pivot table based on dimenions