topic ? in QlikView

?

xyz1 — Sun, 14 Apr 2019 16:16:14 GMT

Re: multiple if condition

Anil_Babu_Samineni — Fri, 11 May 2018 09:37:05 GMT

Does "member of" and "All_Generic_Account" are fields?

?

xyz1 — Sun, 14 Apr 2019 16:16:49 GMT

Re: multiple if condition

bramkn — Fri, 11 May 2018 09:47:16 GMT

if(wildmatch(Member of, '*ALL_Generic_Accounts*')AND (if(wildmatch(Role,'*NO_PWDEXP*') OR wildmatch(Member of,'*ALL_Generic_Accounts*') OR wildmatch(Controls,'*NA*'))

Something like this? having the first one that must apply AND 3 options with OR between em and brackets () arround em

condition1 AND (condition2 OR condition3 OR condition4)

?

xyz1 — Sun, 14 Apr 2019 16:17:49 GMT

Re: multiple if condition

sasiparupudi1 — Fri, 11 May 2018 09:51:41 GMT

May be like this

Count(

{

<["Member of]={'ALL_Generic_Accounts'},Role = {'NO_PWDEXP'}>

<["Member of]={'ALL_Generic_Accounts'},[Claimed/Unclaimed Account]= {'Has Manager'}>

<["Member of]={'ALL_Generic_Accounts'},Controls= {'NA'}>

}

[Accounts])

Re: multiple if condition

Anil_Babu_Samineni — Fri, 11 May 2018 09:56:19 GMT

May be this?

Count({<Role = {'*NO_PWDEXP*'}>+<[Claimed/Unclaimed Account] = {'Has Manager'}>+<Controls = {'NA'}>} If(WildMatch([Member of], '*ALL_Generic_Accounts*'),Accounts)

?

xyz1 — Sun, 14 Apr 2019 16:19:20 GMT

Re: multiple if condition

YoussefBelloum — Fri, 11 May 2018 10:01:56 GMT

if Sasidhar expression works fine for you, try this on a listbox (filter):

=Aggr(Count(

{

<["Member of]={'ALL_Generic_Accounts'},Role = {'NO_PWDEXP'}>

<["Member of]={'ALL_Generic_Accounts'},[Claimed/Unclaimed Account]= {'Has Manager'}>

<["Member of]={'ALL_Generic_Accounts'},Controls= {'NA'}>

}

[Accounts]), Accounts)

?

xyz1 — Sun, 14 Apr 2019 16:15:07 GMT

Re: multiple if condition

Anil_Babu_Samineni — Fri, 11 May 2018 13:10:19 GMT

Perhaps something like this? What does that 88 number?

Count({<Role = {'*NO_PWDEXP*'}>+<[Claimed/Unclaimed Account] = {'Has Manager'}>+<Controls = {'NA'}>+<[Last login Time] = {"$(=(Floor(Date(Today()))-Date([Last login Time]))>88)"}>} If(WildMatch([Member of], '*ALL_Generic_Accounts*'),Accounts)

Re: multiple if condition

Anil_Babu_Samineni — Sat, 12 May 2018 02:10:54 GMT

Agrim Sharma wrote:

if any Account unsatisfied any one of the conditions then it should be unsecured account , so i want total of them

Not sure, I understand this?

?

xyz1 — Sun, 14 Apr 2019 16:19:54 GMT

Re: multiple if condition

Anil_Babu_Samineni — Mon, 14 May 2018 10:38:22 GMT

Why it is not? Let me know the value you got in your Straight table?

Floor(Date(Today()))-Date([Last login Time])

?

xyz1 — Sun, 14 Apr 2019 16:10:44 GMT

Re: multiple if condition

Anil_Babu_Samineni — Mon, 14 May 2018 12:39:38 GMT

Can you create same chart and share QVW to test?

?

xyz1 — Sun, 14 Apr 2019 16:11:16 GMT

Re: multiple if condition

Anil_Babu_Samineni — Mon, 14 May 2018 13:48:00 GMT

This never give output -- =date(Today())-date([Last login Time])

Note - Cause, [Last login Time] contains lot dates not only one.

FYI - When i use this, In text box i got 48?

=Count(If((date(Today())-date([Last login Time]))>80, (date(Today())-date([Last login Time]))))

?

xyz1 — Sun, 14 Apr 2019 16:20:22 GMT

Re: multiple if condition

Anil_Babu_Samineni — Tue, 15 May 2018 23:23:31 GMT

In your model there is no field called "[Claimed/Unclaimed Account]" can you create this and get 5 in text object and the share it here. We will test you. Predominantly it should work. We will try out with in set analysis instead adding/club to each with first one.