Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am hoping someone can help me! I have a large dataset containing info on the types of diagnostic exams patients have. Sometimes a patient can have just one exam, or they can have two, three, four, five etc. Whether they have just one exam or multiple exams, they all are stored under one event for each time they come to Hospital to have this / these scan(s). A sample of the data looks something like this (note this is a fraction of the entire dataset and the event key is always unique for each event date - I've made up the event key here for demo purposes:
AD_Event_Key | AD_Examination |
123456 | CVCOY |
234567 | CABPEC CVCOY |
345678 | CCHAPC CVCOY |
456788 | CVCOY |
567890 | CCHESC CLIVE CVCOY |
678901 | CVCOY |
789012 | CLIVE CVCOY |
890123 | CVCOY |
901234 | CABPEC CVCOY |
112345 | CCHAPC CVCOY |
There are hundreds of these exam codes but I wanted to keep it simple for illustration purposes.
When the data is loaded into QlikView, it's all fine, until we want to do a search on how many times we've performed a certain scan. So, in this example, if I type into the search tool in Qlikview (see attached image) 'CVCOY' it lists all of the entries with 'CVCOY' in it, whether it's a single exam or part of a multiple set of exams. The problem is that due to there being hundreds of exam codes and many many combinations, the search box ends up producing a really long list which then needs to be all selected! Same for list box selection (see attached image).
Is there any way I can tell Qlikview that these codes can be searched on their own i.e. when user types 'CVCOY' they just get 'CVCOY' as a result in the search drop down. The result will then contain every instance of 'CVCOY' as would be expected but for the user perspective I'd like for them to just be able to lookup one specific exam, click on it in the search (or list box) and have QlikView know that it needs to search for all entries contaning 'CVCOY' but to not create a drop down of hundreds of options, for the user to have to select before it produces the results...!?
Your help is much appreciated. Many thanks. I'm sure there's a simple solution but it's evading me!
Include braces around your search string like:
(CVCOY)
try searching this
(CVCOY)
Thanks guys - was looking for a more complicated option but this works perfectly. Will just need to communicate this with the end users! Many thanks. Rgds
Is there a way of adding multiple searches this way so, for example: CVCOY and CLIVE at the same time in the search box??
if you mean eaither
(CVCOY|CVLIVE)
Great - thanks. There is another column (field) in the data source which contains the full name of these examinations, in the same format. So 'CT Virtual Colonoscopy CT Liver' as an example. When I type into the search bar 'Liver' it comes up with all options again. When I use your method of using brackets it displays nothing. Any help greatly received. Rgds