Qlikview Expression

[dunnalahk123]

Hi,

how can i write expression for getting Average days for distinct Customer ID's.

=AVG({$<DISTINCT [Customer ID]>}[Days])

can some one help me please.

Best Regards,

HK

[sunny_talwar · Accepted solution]

May be this

Sum(Aggr(Avg(Days), [Customer ID]))

or this

Avg(Aggr(Avg(Days), [Customer ID]))

[dunnalahk123]

Hi Sunny,

Thanks a lot , you are always Right 🙂

Second Condition works for my need.

Best Regards,

Hk