Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have date against order number and i some order have order date and some order don't have date like pending order So i want to create flag for it.
PFA for expected output.
Thanks
Try like this
in the Dimension tab
if(len(trim(forclosure date))>0,null(),[Order Number])
check the suppress null option
of in the script level
if(len(trim(forclosure date))>0,0,1) as Flag
Hi Sunny / Avinash ,
I am not getting exact output using above logic.
PFA QVD aslo
Vijay,
you need to explain what you need exactly? take a sample data and show us the sample output your excepting then we could help you otherwise will be in no mans land ..
Hi Avinash,
What i exactly want is in this report we are showing pending sales order details with all parameters now user want only that pending order which has not forclosed (base on forclose date). forclosure date is not enter
for example
we are taking order which include both forclose or not forclosed .
forclosed means there is forclosed date front of order number (12/10/12)
and not forclosed means no date available against order ('-')
Thanks
Vijay
As per your data
if(len(trim(forclosure date))>0 and forclosure date<>'NA','Forced Closed' ,'Not Forced Closed') as Flag
Again not getting ....
It is not working because len(trim(ForeclosureDate)) is actually 2.
So condition should be len(trim(ForeclosureDate)) >2.
I checked your QVW , you don't have any - or null values as you mentioned above in the ForeclosureDate that's why its not populating the Not forced close ..check your data set
if(year(ForeclosureDate)='1753','NA', date(ForeclosureDate,'DD-MM-YYYY')) as ForeclosureDate,
,if(len(trim(ForeclosureDate))>0 and (ForeclosureDate)<>'NA','Forced Closed' ,'Not Forced Closed') as Flag
Hi Avinash,
I want to ask you that I have order number "SO/FRM/07032" when i select this then no records showing me in table.
I know that sales order quantity for this order number is 0 but I have to show all records .
Thanks
Un-check suppress zero values in the presentation tab