Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
Creator III

Function

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 ?

null.PNG

Aggr(

  Num(

  Rank(

  If(Sum(

  {

  <

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

  Department = P(Department_S)

  >

  } Count

  )>0,

  Sum(

  {

  <

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

  Department = P(Department_S)

  >

  } Count

  ), null()),

  4

  ),

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

6 Replies
PrashantSangle

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()),

  4

  ),

  '#.##0'

  ),

  Cust_Code

)

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
smilingjohn
Creator III
Creator III
Author

Hi Prashant

I tried this also but its not working

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

PrashantSangle

Hi,

what do you mean not working???

If possible,can you post sample file

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
smilingjohn
Creator III
Creator III
Author

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

BASE.PNG 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 Deselcet.PNG

PrashantSangle

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

Great dreamer's dreams never fulfilled, they are always transcended.
smilingjohn
Creator III
Creator III
Author

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 .

null.PNGis Aggr expression itslef wrong ?