-
Re: Find when a value doesn't exist OR if it net value equals 0
pradosh thakur Oct 17, 2017 12:38 PM (in response to Ben Gardon)script like this . In table A give your table address so it will work
A:
LOAD SALES_ORDER_NUMBER,
PART_NUMBER,
PART_TYPE,
NET_VALUE
FROM
[https://community.qlik.com/thread/278334]
(html, codepage is 1252, embedded labels, table is @1);
//NoConcatenate
left join
LOAD
SALES_ORDER_NUMBER,
if(sum(NET_VALUE)>0,'EDUCATION included ','NOT included') AS ABC
Resident A
WHERE PART_TYPE='Education'
GROUP BY SALES_ORDER_NUMBER
;
NoConcatenate
load
SALES_ORDER_NUMBER,
PART_NUMBER,
PART_TYPE,
NET_VALUE,
IF(TRIM(LEN(ABC))>0,ABC,'NOT included') AS ABC
Resident A;
DROP TABLE A;
edit: This is a qlikview script as i needed to change settings to load webfiles to qliksense . please adjust as per your requirement
regards
Pradosh