Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi To All,
Please find the below Attached file. now my question is in that file some data is there if i load that file in qlikview then in the front end listbox are Source, Date,Time, Type, Message In message list box i want only Xlsx files.how i can get that data ?
Can you be more specific ? Since i don't find the xlsx files
HI Simson,
Please go through the bottom of the database file then u can find the xlsx files.
Hi Simson,
Please go through the bottom of the database file then u can find the xlsx files.
please see file attached.
Regards
RL
sorry i have missed that.
use the expression in the list box : =if(WildMatch(Message,'*.xlsx'),Message)
Use below as LIst box expression:
=SubField(if(wildmatch(Message,'*xlsx')=1, Message,null()),'\',6)
Hope this was helpful or correct.
Thanks,
Angad