Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Luke_Killer_IT
Contributor III
Contributor III

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
Contributor III
Contributor III
Author

Mayil

how to check?

 

Luke_Killer_IT
Contributor III
Contributor III
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
Contributor III
Contributor III
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