topic Re: Listbox by charactor in QlikView

Listbox by charactor

everest226 — Sat, 16 Nov 2024 04:13:57 GMT

I have this value in AP Booking field

5464364ad

3655fcvgh453ddf

5465434TP

45fgfg4TP

I only want to display Value which has TP at the end

bharathadde — Fri, 08 Mar 2019 19:01:43 GMT

Here you go, try this

=if(wildmatch([AP Booking field],'*TP'),[AP Booking field])

everest226 — Fri, 08 Mar 2019 19:04:47 GMT

Thanks