topic Re: Checking condition in QlikView

Checking condition

Mon, 21 Oct 2013 10:28:54 GMT

how to use below SQL code in qlikview i need to check column from tbl1 & if exist then need to

run select * from tbl222; statement...i tried below code

PQR:

IF EXISTS

(

select distinct clumn1 from tbl1

where tbl1.clumn1 ='ABC'

)

select * from tbl222;

Anonymous — Mon, 21 Oct 2013 12:18:50 GMT

Rahul

How about something like this :

PQR:

load sql

select distinct clumn1 from tbl1

where tbl1.clumn1 ='ABC'

;

let vNoOfRows = NoOfRows('SalaryBin') ;

Trace $(vNoOfRows) Rows in table PQR ;

if vNoOfRows > 0 then

let vTraceMess = today() ;

Trace Getting data from tbl222 ;

// and here insert code to get the data from tbl222

else

Trace NOT Getting data from tbl222 ;

endif

Best Regards, Bill

Tue, 22 Oct 2013 05:55:24 GMT

Thanks Bill.....!!