Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Re: Flag for Date

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

vijayptcs
Contributor II

Re: Flag for Date

Hi Sunny / Avinash ,

I am not getting exact output using above logic.

PFA QVD aslo

Re: Flag for Date

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 ..

vijayptcs
Contributor II

Re: Flag for Date

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

Re: Flag for Date

As per your data

if(len(trim(forclosure date))>0 and forclosure date<>'NA','Forced Closed' ,'Not Forced Closed') as Flag

Highlighted
vijayptcs
Contributor II

Re: Flag for Date

Again not getting ....

neelamsaroha157
Valued Contributor II

Re: Flag for Date

It is not working because len(trim(ForeclosureDate)) is actually 2.

So condition should be len(trim(ForeclosureDate)) >2.

Re: Flag for Date

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

vijayptcs
Contributor II

Re: Flag for Date

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

Re: Flag for Date

Un-check suppress zero values in the presentation tab