topic Re: Function in QlikView

Function

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

Hi All,

When i take this expression into a text object i dont see any values in it , and this is what i see as shown in the image . is the expreesion wrong ? or do i need to make some changes to this ?

Aggr(

Num(

Rank(

If(Sum(

{

Date= {">=$(StartDate)<=$(EndDate)"},

Department = P(Department_S)

} Count

)>0,

Sum(

{

Date= {">=$(StartDate)<=$(EndDate)"},

Department = P(Department_S)

} Count

), null()),

'#.##0'

Cust_Code

)

There is a variable within which we have below mentioned expression, is there any way to include within the this a expression which will neglect the selection made out side for the field 'BASE'

and the field BASE has two value in it 'A' and 'B' ......and by default using some triger they have set the BASE to 'A'

and i want to exclude the BASE selection in the bove expression.

Thanks in advance

Re: Function

PrashantSangle — Tue, 14 Mar 2017 06:09:28 GMT

Hi,

try below

Aggr(

Num(

Rank(

If(Sum(

{

Date= {">=$(StartDate)<=$(EndDate)"},

Department = P(Department_S),

BASE=

} Count

)>0,

Sum(

{

Date= {">=$(StartDate)<=$(EndDate)"},

Department = P(Department_S),

BASE=

} Count

), null()),

'#.##0'

Cust_Code

)

Regards,

Re: Function

smilingjohn — Tue, 14 Mar 2017 06:12:31 GMT

Hi Prashant

I tried this also but its not working

. is there any way to deselect BASE within this expression ?

Re: Function

PrashantSangle — Tue, 14 Mar 2017 06:17:03 GMT

Hi,

what do you mean not working???

If possible,can you post sample file

Regards,

Re: Function

smilingjohn — Tue, 14 Mar 2017 06:25:56 GMT

There is an external trigger being set by which always 'A' values is being selected in thtr BASE field.

and i have to manaulyy deselect ' A' to get the values ... therefore i wanted an expression which will deselct the 'A' within BASE and give the out put..

Below is the attachment screen which is selected bydefualt ....

and when i manaully deselect A then there will be out put for me for the above expression , and it will be like this after delsecting

Re: Function

PrashantSangle — Tue, 14 Mar 2017 06:46:09 GMT

Hi,

when you nullify any fields it will give result which will not consider your selection.

try this in text object

Sum(

{

Date= {">=$(StartDate)<=$(EndDate)"},

Department = P(Department_S),

BASE=

} Count

)

Regards,

Prashant

Re: Function

smilingjohn — Tue, 14 Mar 2017 07:03:34 GMT

This works Prashanth,

When i take ur expression into text object it works but when i take my expression into a text object it gives me - values, attached in the screen shot .

is Aggr expression itslef wrong ?