topic Re: Flag for Date in QlikView

Flag for Date

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Flag for Date

sunny_talwar — Fri, 31 Mar 2017 08:08:01 GMT

May be like this

LOAD Order,

Date,

If(Len(Trim(Date)) = 0, 'Pending Order', 'Order Done') as Flag

FROM ....;

Re: Flag for Date

Anonymous — Fri, 31 Mar 2017 08:16:42 GMT

Hi Sunny,

I dont have any null values in date so if i use your solution then it is getting only Order Done in flag.

Re: Flag for Date

ahaahaaha — Fri, 31 Mar 2017 08:24:27 GMT

Hi,

May be like this

LOAD Order,

Date,

If(Left(Order, 5)=' ORD/', 'Order Done', 'Pending Order') as Flag

FROM ....;

Regards,

Andrey

Re: Flag for Date

Anonymous — Fri, 31 Mar 2017 09:17:33 GMT

PFA ...

Any suggestion ...

Re: Flag for Date

avinashelite — Fri, 31 Mar 2017 09:51:17 GMT

on which column base you need this flag to be create ?? could elaborate bit more

Re: Flag for Date

Anonymous — Fri, 31 Mar 2017 10:02:21 GMT

Based on Order number.

Re: Flag for Date

sunny_talwar — Fri, 31 Mar 2017 10:44:04 GMT

What are you trying to do in the attached file? Would you be able to elaborate?

Re: Flag for Date

Anonymous — Fri, 31 Mar 2017 10:49:16 GMT

In my chart i don't want those order number which they have forclosure date .

Re: Flag for Date

sunny_talwar — Fri, 31 Mar 2017 10:51:13 GMT

May be this?

Re: Flag for Date

avinashelite — Fri, 31 Mar 2017 11:15:38 GMT

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

Re: Flag for Date

Anonymous — Fri, 31 Mar 2017 11:41:43 GMT

Hi Sunny / Avinash ,

I am not getting exact output using above logic.

PFA QVD aslo

Re: Flag for Date

avinashelite — Fri, 31 Mar 2017 11:51:37 GMT

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

Re: Flag for Date

Anonymous — Fri, 31 Mar 2017 12:21:26 GMT

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

avinashelite — Fri, 31 Mar 2017 12:36:10 GMT

As per your data

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

Re: Flag for Date

Anonymous — Fri, 31 Mar 2017 12:40:57 GMT

Again not getting ....

Re: Flag for Date

neelamsaroha157 — Fri, 31 Mar 2017 12:56:19 GMT

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

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

Re: Flag for Date

avinashelite — Fri, 31 Mar 2017 13:05:15 GMT

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

Re: Flag for Date

Anonymous — Sat, 01 Apr 2017 07:43:35 GMT

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

avinashelite — Sat, 01 Apr 2017 17:23:34 GMT

Un-check suppress zero values in the presentation tab