Discussion board where members can get started with QlikView.
How can I get the lowest value among 4 amount columns for a given policy. Attached is the qvw for reference.
Given Data Set:
Go to Solution.
May be this
If(Sum(AMOUNT1) = 0, 1E10, Sum(AMOUNT1)),
If(Sum(AMOUNT2) = 0, 1E10, Sum(AMOUNT2)),
If(Sum(AMOUNT3) = 0, 1E10, Sum(AMOUNT3)),
If(Sum(AMOUNT4) = 0, 1E10, Sum(AMOUNT4)))
You can use cross table for this.
Crosstable(Amount_no,Amount,3) Load * From Table;
Min(Amount) as Amount
Group by State,City;
I hope this helps.