topic Filter data based on value in QlikView

Filter data based on value

Tue, 18 Oct 2011 19:01:48 GMT

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

Filter data based on value

its_anandrjs — Tue, 18 Oct 2011 19:20:21 GMT

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