topic Re: Regarding logic in QlikView

Regarding logic

d_koti24 — Tue, 13 Oct 2015 15:55:29 GMT

Hi All,

PFA

i am loading the data from log file.to retrive file path and extension ,i.e fine.in my extension file contains 4 extensions

like:

qvd(qvd),

qvd,

xls,

xlsx

my req is i want dispaly only 2 extn's in list box like qvd,xlsx instead of 4.when i click qvd i want to reflect the data for both fields(

qvd(qvd),

qvd,)

same vise versa.

How to achive this?

regards,

Kd.

Clever_Anjos — Tue, 13 Oct 2015 15:57:50 GMT

this should solve

Loc:

load

if(LEFT(SubField(locations,' ',6),1)='F',mid(locations,index(locations,' ',6),len(locations)-index(locations,' ',6)+1),

mid(locations,index(locations,' ',4),len(locations)-index(locations,' ',4)+1)) as loc,

locations,

left(SubField( SubField(locations,'.',-1),']'),3) as extn

Resident Test;

d_koti24 — Tue, 13 Oct 2015 16:07:48 GMT

Thanks for Quick reply Clever Anjos

It's working fine,but i am getting one extra space in list box

how to remove that one