Pick() Match() with '>=*' condition. Is it possible?

[shyamcharan]

Hi Experts,

I am trying to create a calculated condition and my requirement is something like below:

IF(Code='1A' AND Seconds >=600, 'High','Low')

Can i get it done with Pick() match() ?

Thanks in advance.

[shyamcharan]

Hi Anil,

Sorry I have now corrected my earlier post.

It should be 2i & 2ie & r2 NOT just 2i. Hope this clears confusion.

Also, I have reviewed and the condition is correct.

sorry again for the confusion.

[Anil_Babu_Samineni]

Till Approx how many codes you have in real data? I am expecting number

[shyamcharan]

I have around 40 codes, but what all I want is just the below codes and the below output out of all the codes and data:

Dimension          Measure(time condition)          All Measures

1a                              2                                        3

1b & 1c                      6                                         7

2i  & 2ie & r2              4                                        10

2a & 2b                       5                                        7

r3                                2                                        5

[shyamcharan · Accepted solution]

Hi Anil,

I think i found it.

Please review the attached qvw and let me know your thoughts..

I used the logic:

=Count({<Code={'1a'},Time={'>=15'}>+

  <Code={'1b','1c'},Time={'>=30'}>+

  <Code={'2I','2IE','r2'},Time={'>=150'}>+

  <Code={'2a','2b'},Time={'>=210'}>+

  <Code={'r3'},Time={'>=290'}>}Measure)

[Anil_Babu_Samineni]

If you feel those values are good, Then it's good. Close this thread by flag Correct Answer of your reply.