topic Re: Loading data in QlikView

Loading data

prabhas277 — Wed, 01 Apr 2015 14:16:13 GMT

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 ?

Re: Loading data

simsondevadoss — Wed, 01 Apr 2015 14:24:58 GMT

Can you be more specific ? Since i don't find the xlsx files

Re: Loading data

prabhas277 — Wed, 01 Apr 2015 14:34:49 GMT

HI Simson,

Please go through the bottom of the database file then u can find the xlsx files.

Re: Loading data

prabhas277 — Wed, 01 Apr 2015 14:42:11 GMT

Hi Simson,

Please go through the bottom of the database file then u can find the xlsx files.

Re: Loading data

Wed, 01 Apr 2015 14:42:17 GMT

please see file attached.

Regards

Re: Loading data

simsondevadoss — Wed, 01 Apr 2015 14:58:52 GMT

sorry i have missed that.

use the expression in the list box : =if(WildMatch(Message,'*.xlsx'),Message)

Re: Loading data

Wed, 01 Apr 2015 16:35:51 GMT

Use below as LIst box expression:

=SubField(if(wildmatch(Message,'*xlsx')=1, Message,null()),'\',6)

Hope this was helpful or correct.

Thanks,

Angad