topic Re: selection ISSUEs in QlikView

selection ISSUEs

mario-sarkis — Thu, 20 Aug 2015 07:39:20 GMT

hey all i wrote this Expression in to calculate the sum of a balance with these condition , ignoring all selection except [RM User],[BRANCH] and [RM Full Name] by putting 1 befor the condition as shown in the below expression , but my prom the expression it still effect with other selection

such as "Month","Year"....., Should i add something to this expression ? Please Help.

=(sum({ 1

< [RM User]=$::[RM User]

,[BRANCH]=$::[BRANCH]

,[RM Full Name]=$::[RM Full Name]

,[RM Party]={1}

,[RM Product/GL]={'Product'}

,Date={'$(=Date(Max(DateFinance),'M/D/YYYY'))'}

} Balance))

Thank you,

Re: selection ISSUEs

jonathandienst — Thu, 20 Aug 2015 07:55:23 GMT

I think this is what you need:

=sum({1<

RM User]=P([RM User])

,[BRANCH]=P([BRANCH])

,[RM Full Name]=P([RM Full Name])

,[RM Party]=

,[RM Product/GL]={'Product'}

,Date={"$(=Date(Max(DateFinance),'M/D/YYYY'))"}

Balance)

=sum({1<

RM User]=P([RM User])

,[BRANCH]=P([BRANCH])

,[RM Full Name]=P([RM Full Name])

,[RM Product/GL]={'Product'}

,Date={"$(=Date(Max(DateFinance),'M/D/YYYY'))"}

Balance)

Re: selection ISSUEs

jonathandienst — Thu, 20 Aug 2015 07:56:12 GMT

Another option to try for RM Party is:

,[RM Party]=P({1} [RM Party])

Re: selection ISSUEs

mario-sarkis — Thu, 20 Aug 2015 08:04:35 GMT

hi jonathan, i need the [RM Party] to be equal to 1 , thats why i wrote it [RM PArty]={1}

Re: selection ISSUEs

mario-sarkis — Thu, 20 Aug 2015 08:06:59 GMT

should i change something in this >>>Date={"$(=Date(Max(DateFinance),'M/D/YYYY'))"} ???