Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
shyamcharan
Creator III
Creator III

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

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.

14 Replies
shyamcharan
Creator III
Creator III
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
shyamcharan
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful