topic Re: Exclude data in App Development

Exclude data

paulwalker — Tue, 23 May 2023 12:05:29 GMT

HI Community,

I have to exclude data if value is less than 11 (if any records falling under value 11 that should be exclude group level)

let say Name=ABC has two records, values are 10 and 15 (these records should be exclude because falling under less than 11 bucket)

below is my sample data

LOAD * INLINE [
Name, Product, value
ABC, A1, 10
ABC, A2, 15
BCA, B1, 9
BCA, B2, 12
XYZ, X1, 19
XYZ, X2, 21
CAA, C1, 34
ZZZ, Z1, 9
];

SUM({<value={">10"}>}value) - this expression not giving correct result

my output should be

Thanks in Advance!

Re: Exclude data

Chanty4u — Tue, 23 May 2023 12:12:48 GMT

Try this

SUM({<Name = {"=MIN(value) >= 11"}>} value)

Re: Exclude data

Kushal_Chawda — Tue, 23 May 2023 14:18:03 GMT

@paulwalker this is the best way I could think of

LOAD *, Name & Product as Dimension_Key INLINE [ Name, Product, value ABC, A1, 10 ABC, A2, 15 BCA, B1, 9 BCA, B2, 12 XYZ, X1, 19 XYZ, X2, 21 CAA, C1, 34 ZZZ, Z1, 9 ]; AUTONUMBER Dimension_Key; Add more dimension to Key if you are going to have more dimension in your table create a table with Dimension Name, Product with below expression =sum({<Name=p({<Dimension_Key={"=sum(value)>10"}>}Name) - p({<Dimension_Key={"=sum(value)<=10"}>}Name)>}value)

Re: Exclude data

PrashantSangle — Tue, 23 May 2023 14:35:17 GMT

you can create flag in back end for same and using same flag you can remove it from table

Test:
LOAD * INLINE [
Name, Product, value
ABC, A1, 10
ABC, A2, 15
BCA, B1, 9
BCA, B2, 12
XYZ, X1, 19
XYZ, X2, 21
CAA, C1, 34
ZZZ, Z1, 9
];

Left Join
Temp:
Load Name, if(min_value<11,'1','0') as flag;
Load Name, min(value) as min_value Resident Test group by Name;

In front end

take > table

dimension > Name , Product

measure > Sum({<flag={'0'}>}value)

Regards,

Prashant Sangle