I have created a report as attached in qlikview. As per our requirement I need to create a new report using existing attached report.the condition to create new report as follow:
If(X-Amount <> max( Y-Amount , Z-Amount)
based on above condition I need to display all columns values in new report which are satisfied condition.
I able to display all records in new report which are satisfied above condition but one extra record (Sub category : aaa) is displaying in the new report .but we need to considered X amount as 123 only and based on this value we can exclude this record.
I unable to exclude this record in the report. Please suggest solution on this and provide expression for this.
Note: the fact value which are populated from database as shown as attached report only but we used Number format for all facts values as 'Money' in the existing report then Sun Category - aaa -X-mount considered as 123 in our Qlik report.Based on this value only we need to exclude this SubCat value from new report.
