Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Filter data based on value

I am trying to develop a detailed list of claims data in a table for an insurance company.  I'd like to be able to create filters so that I only show claims that have loss values greater than $10,000 and a second filter to display claims with values greater than $25,000.  Can anyone help me with how best to do this?  My objective is to be able to cycle through the same table but only showing claims greater than those two values.

I have attached a overly simplified version of the data

1 Solution

Accepted Solutions

Filter data based on value

Hi,

You need to write for straight table like

Dimension -> Claim #

Dimension -> Policy #

Expression -> If( [Loss Paid] >= 10000 or [Loss Paid] >= 25000, [Loss Paid])

Rgds

Anand

1 Reply

Filter data based on value

Hi,

You need to write for straight table like

Dimension -> Claim #

Dimension -> Policy #

Expression -> If( [Loss Paid] >= 10000 or [Loss Paid] >= 25000, [Loss Paid])

Rgds

Anand