This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I need to subtract null values(12495000 - 12494342) and display in DIFFERENCE column. Please help..
It depends on what you are trying to do
but you can change if it's a list box to treat a null symbol as 0
I created a Chart as table with 2 data sources as part of ETL testing on the key BUSINESS_PLAN_RCVD_DT_SBL:
1. SELECT (CASE WHEN PRTNR_TYPE_CD IS NOT NULL THEN c.[X_BUS_PLAN_RECVD_DT]ELSE NULLEND) AS BUSINESS_PLAN_RCVD_DT_SBL, COUNT(1) AS BUSINESS_PLAN_RCVD_DT_SBLfrom COMMON.dbo.W_SBL_S_EXT c
GROUP BY (CASE WHEN PRTNR_TYPE_CD IS NOT NULL THEN c.[X_BUS_PLAN_RECVD_DT]ELSE NULLEND)ORDER BY 2;
2. SELECT BUSINESS_PLAN_RCVD_DT AS BUSINESS_PLAN_RCVD_DT_SBL,
COUNT(1) AS BUSINESS_PLAN_RCVD_DT_GDW
FROM GDW.dbo.T_DIM_ACCOUNT WHERE SRC_APP_CD = 'SBL' AND SRC_DELETE_FLG = 'N'GROUP BY BUSINESS_PLAN_RCVD_DTORDER BY 2;
thye both have NULL vallues but not in the same row..