topic Re: Flag in QlikView

Flag

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Am trying to create flag for DOJ if it exceeds Target date

Then it will load employee count for next month

My script look like this

Load

Emp code,

If(DOJ>Target date, dual(addmonths(DOJ,1),1),0) as flag1

Resident table;

But not working properly

Any help???

Re: Flag

Mon, 06 Mar 2017 08:48:40 GMT

Any suggestions please help!!!

Re: Flag

ahaahaaha — Mon, 06 Mar 2017 08:59:14 GMT

Hi,

Little would fragment the source data, and you want to get in result.

Regards,

Andrey

Re: Flag

Anil_Babu_Samineni — Mon, 06 Mar 2017 09:06:47 GMT

May be this

If(DOJ>[Target date],1,0) as flag1

Then use this expression

Count({<flag = {'1'}, Month = {'$(=AddMonths(Max(Month),1))'}>}employee)

Re: Flag

jonathandienst — Mon, 06 Mar 2017 09:23:20 GMT

The field flag1 can only have a single text representation* for the value of 1. You presumably have multiple values of DOJ greater than the target - only the last one will survive. I think what you need is:

If(DOJ > [Target date],

Dual('Yes',1),

Dual('No', 0)

)as flag1

*the first parameter in Dual()

Re: Flag

Mon, 06 Mar 2017 11:54:46 GMT

Hi anil,

Your expression looks like correct I applied the same but not giving accurate results....

Pls help

Re: Flag

Anil_Babu_Samineni — Mon, 06 Mar 2017 11:59:43 GMT

If possible please share sample to look so that we can look diff ways if we can

Re: Flag

Mon, 06 Mar 2017 14:16:49 GMT

These are the fields which we have

Load

com-code,

Emp-code,

Requisition no,

Requisition date,

Target date,

DOJ,

No of people required,

If(DOJ>Target date, 1, 0) as flag1

Resident table;

Any suggestions???

Re: Flag

Anil_Babu_Samineni — Mon, 06 Mar 2017 15:12:23 GMT

I meant it as Data points to show, Because you've mentioned given expression is working but not giving Accurate values. I am not talking about this. Would you provide sample which demonstrates the Output

Re: Flag

Mon, 06 Mar 2017 15:51:59 GMT

Thanks for ur reply......

This is I want to show in straight table.

Dimensions> requisition number, requisition date, Target date

And expression(which I have explained)

Pls suggest