Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Error filtering data in simple table

How are you,

I have a problem filtering records in a simple table, when I filter a field I get more records. see images.

Table:

Foto1.png

Tabla Aggregate

Foto2.png

Filter >80

Foto4.png

Values less than 80 are displayed

Foto6.png

Thanks

Juan Monasí

Tags (1)
Labels (1)
3 Replies
Highlighted
Specialist
Specialist

Re: Error filtering data in simple table

whats your formula for total and what are your dimensions?

Can you provide a sample app?

Highlighted
Contributor
Contributor

Re: Error filtering data in simple table

Hi,

I attach the document

Highlighted
Specialist
Specialist

Re: Error filtering data in simple table

Hi Juan,

I have looked at your data. Column F is being aggregated as Sum(F).

The search happening on your Total column for >80 selects its respective dimensions.

i.e. for Sum(F) > 80 in the straight table selects B -1,2 and C - F1, F2, F4.

Selections are always made on Dimensions, not on expressions.

I have added a Current Selections Object which shows you the selections made.

Alternatively, if your search has to be user based then create a list box or Multi box for column F.