topic Re: only function alterative in QlikView

only function alterative

shivam0703 — Thu, 10 Jun 2021 13:59:14 GMT

=Aggr(only(
{$<
Date = {">=$(StartDate)<=$(EndDate)"},
Hierarchy = P(Hierarchy) * P(Hierarchy_S)
>} Lead_ID)
,Lead_UID)

----------------------------------------------------------------------------------------------------------------

I have above expression used in straight table but I have 2 lead id for this so no data is seen how can I get both the lead id so what can be the atlernative expression for this

Re: only function alterative

sunny_talwar — Thu, 10 Jun 2021 15:36:55 GMT

Are you using this as a expression or dimension?

Re: only function alterative

shivam0703 — Fri, 11 Jun 2021 09:38:35 GMT

It's a dimension

Re: only function alterative

sunny_talwar — Fri, 11 Jun 2021 12:57:53 GMT

Are there two fields Lead_ID and Lead_UID? If there are, may you need this?

=Aggr( Only({$<Date = {">=$(StartDate)<=$(EndDate)"}, Hierarchy = P(Hierarchy) * P(Hierarchy_S)>} Lead_ID) , Lead_UID, Lead_ID)