topic Re: object_doubt in QlikView https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434424#M818583 <HTML><HEAD></HEAD><BODY><P>Hi Antony,</P><P></P><P>try to use calculate Dimension in List&nbsp; box As Follow:</P><P></P><P><STRONG>=If(WildMatch([login time],'6:30:00','16:30:00','22:30:00'),<SPAN style="font-size: 13.3333px;">[login time]</SPAN>)</STRONG></P><P></P><P></P><P>Thanks,</P><P></P><P>Arvind Patil</P></BODY></HTML> Mon, 21 Aug 2017 06:46:46 GMT arvind_patil 2017-08-21T06:46:46Z object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434422#M818581 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a list box and it contains shift times But here I don't want to show all the shifts.</P><P>I want to display only particular times like 6:30:00 AM, 4:30:00 PM, 10:30:00 PM</P><P></P><P><IMG __jive_id="173977" alt="list_doubt.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/173977_list_doubt.JPG" style="height: auto;" /></P><P></P><P>I have tried with combination of pick and match.</P><P></P><P>=Time(Pick(Match([login time],'6:30','16:30','22:30'),'6:30','16:30','22:30'),'hh:mm:ss TT')</P><P></P><P>but it is not working.</P><P></P><P>any suggestions will be appreciated.</P><P></P><P>Thanks in advance!!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434422#M818581 antonybi 2020-11-25T16:16:04Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434423#M818582 <HTML><HEAD></HEAD><BODY><P>don't use Pick match here, I know your intention. Should be this?</P><P><STRONG>If(Match([login time], '6:30','16:30','22:30'), [login time])</STRONG></P></BODY></HTML> Mon, 21 Aug 2017 06:46:25 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434423#M818582 Anil_Babu_Samineni 2017-08-21T06:46:25Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434424#M818583 <HTML><HEAD></HEAD><BODY><P>Hi Antony,</P><P></P><P>try to use calculate Dimension in List&nbsp; box As Follow:</P><P></P><P><STRONG>=If(WildMatch([login time],'6:30:00','16:30:00','22:30:00'),<SPAN style="font-size: 13.3333px;">[login time]</SPAN>)</STRONG></P><P></P><P></P><P>Thanks,</P><P></P><P>Arvind Patil</P></BODY></HTML> Mon, 21 Aug 2017 06:46:46 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434424#M818583 arvind_patil 2017-08-21T06:46:46Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434425#M818584 <HTML><HEAD></HEAD><BODY><P>Still it is not showing anything I have tried the same as you suggested.</P><P></P><P>PFA for your reference!!</P></BODY></HTML> Mon, 21 Aug 2017 06:57:08 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434425#M818584 antonybi 2017-08-21T06:57:08Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434426#M818585 <HTML><HEAD></HEAD><BODY><P>Looks like showing?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174003_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 21 Aug 2017 07:01:26 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434426#M818585 Anil_Babu_Samineni 2017-08-21T07:01:26Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434427#M818586 <HTML><HEAD></HEAD><BODY><P>Or this?</P><P></P><P><STRONG>=If(Match([login time], '6:30','16:30','22:30'), TimeStamp([login time]))</STRONG></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174004_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 21 Aug 2017 07:03:01 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434427#M818586 Anil_Babu_Samineni 2017-08-21T07:03:01Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434428#M818587 <HTML><HEAD></HEAD><BODY><P>No it is not showing anything.</P></BODY></HTML> Mon, 21 Aug 2017 07:03:47 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434428#M818587 antonybi 2017-08-21T07:03:47Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434429#M818588 <HTML><HEAD></HEAD><BODY><P>I just opened your application? Check my replies with screenshots.</P></BODY></HTML> Mon, 21 Aug 2017 07:05:24 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434429#M818588 Anil_Babu_Samineni 2017-08-21T07:05:24Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434430#M818590 <HTML><HEAD></HEAD><BODY><P>Both expressions I have tried but it is still not showing anything.</P><P></P><P>what's wrong with this??</P><P></P><P>Can you do it in my application which shared in the below.</P></BODY></HTML> Mon, 21 Aug 2017 07:06:50 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434430#M818590 antonybi 2017-08-21T07:06:50Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434431#M818592 <HTML><HEAD></HEAD><BODY><P>May be share your image, Where it is not working for you</P></BODY></HTML> Mon, 21 Aug 2017 07:09:19 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434431#M818592 Anil_Babu_Samineni 2017-08-21T07:09:19Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434432#M818594 <HTML><HEAD></HEAD><BODY><P>I think it is something wrong in my application can you check it out?</P></BODY></HTML> Mon, 21 Aug 2017 07:09:32 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434432#M818594 antonybi 2017-08-21T07:09:32Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434433#M818596 <HTML><HEAD></HEAD><BODY><P>PFB for your reference</P><P></P><P><IMG alt="list2.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174005_list2.JPG" style="font-size: 13.3333px;" /></P><P><IMG alt="list3.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/174006_list3.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 21 Aug 2017 07:14:49 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434433#M818596 antonybi 2017-08-21T07:14:49Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434434#M818599 <HTML><HEAD></HEAD><BODY><P>Expression correct only, and in your script there is not good connection. Could be the reason?</P></BODY></HTML> Mon, 21 Aug 2017 07:18:50 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434434#M818599 Anil_Babu_Samineni 2017-08-21T07:18:50Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434435#M818601 <HTML><HEAD></HEAD><BODY><P>Hi Antony,</P><P></P><P>Try:</P><P>=Aggr(if(Match([login time],'6:30','16:30','22:30'),Time([login time])),[login time])</P><P></P><P>as the expression in a listbox.</P><P></P><P>Cheers</P><P></P><P></P><P>Andrew</P></BODY></HTML> Mon, 21 Aug 2017 07:28:15 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434435#M818601 effinty2112 2017-08-21T07:28:15Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434436#M818602 <HTML><HEAD></HEAD><BODY><P>No. Now I configured correct connect even though I am getting same issue.</P><P></P><P>I don't&nbsp; understand whats really wrong with this?</P></BODY></HTML> Mon, 21 Aug 2017 07:29:01 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434436#M818602 antonybi 2017-08-21T07:29:01Z Re: object_doubt https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434437#M818604 <HTML><HEAD></HEAD><BODY><P>Hey thank you so much it worked.</P></BODY></HTML> Mon, 21 Aug 2017 07:31:48 GMT https://community.qlik.com/t5/QlikView/object-doubt/m-p/1434437#M818604 antonybi 2017-08-21T07:31:48Z