Set analysis

[#1]

Hi all,

In the pie chart I need to exclude the data of batch_meta_data_id = {1,4,5} and I want to select the data of only, final_test_status = {'passed'} ,version={'v1'}.

Is the below expression is correct? If not please help with the correct one.

SUM({$-1<batch_meta_data_id = {1, 4, 5},final_test_status = {'passed'},version={'v1'}>}browser_visits)

Thanks,

Pramod

[#2]

Hi jonathan,

Thanks for the reply.

I am applied RangeMax() for below expressions but it's not working and i cross checked with the DB and i have only zero values no negative values.

1. Sum({$<browser_visits=p({<version={'v1','v2'}>}),batch_meta_data_id -= {1, 4, 5},

final_test_status = {'passed'}>}browser_visits)

2. Sum({$< browser_visits=p({<version={'v2'}-p({<version={'v1'}>})>}), batch_meta_data_id -= {1, 4, 5},

final_test_status = {'passed'}>}browser_visits)

Regards,

Pramod

[jonathandienst]

I suggest that you post your qvf file or a sample that illustrates the problem.

[#4]

Hi jonathan,

Please find the .qvf.

Thanks,

Pramod

[ankitbisht01]

There are two methods

1.  SUM({<batch_meta_data_id -= {'1', '4', '5'},final_test_status = {'passed'},version={'v1'}>}browser_visits)

2.  SUM({<batch_meta_data_id =E({<ID={1,4,5}>}) ,final_test_status = {'passed'},version={'v1'}> }browser_visits )

Best Regards

Ankit Bisht