Wrong aggrgeate value in Trend chart

[pawwy1415]

Hi,

I am using below expression in DImension..

=Aggr(If(Rank(MonthYear,4)<=6, MonthYear), MonthYear)

and

BELOW IS AS EXPRESSION

Sum({$<[Met]={'PX'},[Metric]-={"'-'"},Group-={"''-"}>}Number)

I want last month trend, which working fine but giving some aggregate value (attach screenshot).. could you please look what's wrong in the code which is bringing this aggregate value.

Thanks

[Anil_Babu_Samineni]

When you do with some calculation as dimension you need to suppress from that dimension. Can you check "Suppress When Value is Null" option box should be checked

[pawwy1415]

Hi Anil,

Sorry, I forgot to mention, I am using Qlik Sense and there is suppress option in Qlik Sense..

[Anil_Babu_Samineni]

Yes, It is there called "Include Null Values" you need to disable that?

[sunny_talwar]

May be try this... basically use set analysis instead of calculated dimension to restrict MonthYear field.....

Dimension

MonthYear

Expression

Sum({$<[Met]={'PX'},[Metric]-={"'-'"},Group-={"''-"}, MonthYear = {"=Rank(MonthYear, 4) <= 6"}>}Number)

[pawwy1415]

Thanks both it's resolved now.