Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
su88rao
Partner - Contributor III
Partner - Contributor III

applying filters in qliksense expression for pivot table for multiple dimensions

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

classificationbrandCount of productid
ABCTotal10
JSDJS5
DJDJD5
DEFTotal5
TDYDU5
GHITotal23
FDSDDS7
DKNDKO6
UISIOA5
MAJKN5
JKLTotal22
YAYUA5
LJSJJD17
Grand Total 60

 

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

classificationbrandCount of productid
ABCTotal10
JSDJS5
DJDJD5
DEFTotal5
TDYDU5
GHITotal23
FDSDDS7
DKNDKO6
YAYUA5
MAJKN5
JKLTotal24
KQDMNF5
LJSJJD17
YAYUA2
MNOTotal1
YAYUA1
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)
Labels (3)
1 Solution

Accepted Solutions
su88rao
Partner - Contributor III
Partner - Contributor III
Author

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 🙂

View solution in original post

1 Reply
su88rao
Partner - Contributor III
Partner - Contributor III
Author

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 🙂