topic Re: if statement expression syntax in QlikView

if statement expression syntax

anonymous1 — Sat, 16 Nov 2024 02:54:45 GMT

hi,

i am trying to create a line chart that uses DEPOT_ID as a dimension and i need the y-axis to count the ITEM_QTY provided the item was shipped before today and has not yet been received. my table structure is:

DEPT_TABLE:
LOAD

DEPOT_ID,
Date(SHIP_DATE, 'MMM-YYYY') as SHIP_DATE,
Date(RECEIVED_DATE, 'MMM-YYYY') as RECEIVED_DATE ,
ITEM_TYPE_ID,
ITEM_ID,
NUM(QTY) as QTY

ive tried using this expression:

=IF([SHIP_DATE] < TODAY() and [RECEIVED_DATE]>TODAY() , sum(QTY))

but my graph is showing nothing, i think maybe my syntax is incorrect?

Re: if statement expression syntax

tresB — Thu, 25 Jul 2019 09:37:44 GMT

Try using sum(if( rather than if(sum( like:

=Sum(IF([SHIP_DATE] < TODAY() and [RECEIVED_DATE]>TODAY() , QTY))

Re: if statement expression syntax

Frank_Hartmann — Thu, 25 Jul 2019 09:42:22 GMT

Maybe this:

DEPT_TABLE: LOAD DEPOT_ID, Date#(SHIP_DATE, 'MMM-YYYY') as SHIP_DATE, Date#(RECEIVED_DATE, 'MMM-YYYY') as RECEIVED_DATE , ITEM_TYPE_ID, ITEM_ID, NUM(QTY) as QTY