Set Analysis

[mahendragaur]

Hello,

I have a list of Process and out of which I want only Process "a" & "b" data in sheet. I used Set for the same. But my requirement is

1> If user select only process "a" then it should show data for process "a"

2> If user select any process other than "a" & "b" then it should show data for "a" & "b" only.

Attached is my qvw

[saniyask]

Hi,

Can you please reload the application and then attach it or attach the data set.

Regards,

Saniya

[tresesco]

Just put a '*' before '=' in your set analysis like:

Sum({$<Process*={'a','b'}>}Value)

[Anil_Babu_Samineni · Accepted solution]

May be this?

If(GetFieldSelections(Process)='a' or GetFieldSelections(Process)='b',Sum(Value), Sum({<Process = {'a', 'b'}>}Value))

[manideep78]

Hi,

Here is the expression,

=If(GetFieldSelections(Process)='a' or GetFieldSelections(Process)='b', sum(Value),sum({<Process={'a','b'}>}Value))

[manideep78]

This is amazing. tresesco‌ can you please share the resources where I can learn these type of simple tricks.

[tresesco]

  For this one: Implicit Set Operators

[mahendragaur]

No this is not solving my purpose because if I'm selecting any process type other than a & b then it is not showing any data.

[mahendragaur]

Thanks buddy...

[mahendragaur]

What if I need a, b and c as well