Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Luke_Killer_IT
Creator
Creator

Data is not filtering

Hello
I have a problem with data filtering, it does not work as shown in the screenshot, what could be the reason? and how to solve it?

Luke_Killer_IT_0-1623398727583.png

 

1 Solution

Accepted Solutions
MayilVahanan

Hi

In ur first expression, change the expression like below to impact ur selection

Sum({<ArticleGroup*={510,520, 530}>}OnHand)

Thanks & Regards,
Mayil Vahanan R

View solution in original post

6 Replies
MayilVahanan

HI

Might be, ur expression exclude the fields selection..

 

Thanks & Regards,
Mayil Vahanan R
Luke_Killer_IT
Creator
Creator
Author

Mayil

how to check?

 

Luke_Killer_IT
Creator
Creator
Author

Mayil
look at this when i click sort like this

Luke_Killer_IT_0-1623406875895.png

it  works  but this filter gets from another table which is not even displayed while in pivot table I only have data from two tables but they are linked and can't filter them, listbox is from this table which is in pivot table.

Luke_Killer_IT_1-1623407253220.png

 

Luke_Killer_IT_3-1623407316878.png

Luke_Killer_IT_0-1623407440277.png

 

 

 

MayilVahanan

Hi Luke,

Can you attach ur sample qv file?

OR can you paste ur expresssions?

Thanks & Regards,
Mayil Vahanan R
Luke_Killer_IT
Creator
Creator
Author

Hi Mayil,

I don't know if you meant that

Luke_Killer_IT_0-1623667403117.png

Luke_Killer_IT_1-1623667426489.pngLuke_Killer_IT_2-1623667435557.png

 

MayilVahanan

Hi

In ur first expression, change the expression like below to impact ur selection

Sum({<ArticleGroup*={510,520, 530}>}OnHand)

Thanks & Regards,
Mayil Vahanan R

View solution in original post