topic Re: Qlikview Expression in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/30458#M771850 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Thanks a lot , you are always Right <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Second Condition works for my need.</P><P></P><P>Best Regards,</P><P>Hk</P></BODY></HTML> Wed, 30 May 2018 11:24:10 GMT dunnalahk123 2018-05-30T11:24:10Z Qlikview Expression https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/30456#M771848 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>how can i write expression for getting Average days for distinct Customer ID's.</P><P></P><P>=AVG({$&lt;DISTINCT [Customer ID]&gt;}[Days])</P><P></P><P>can some one help me please.</P><P></P><P>Best Regards,</P><P>HK</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/30456#M771848 dunnalahk123 2020-11-25T16:16:04Z Re: Qlikview Expression https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/30457#M771849 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(Aggr(Avg(Days), [Customer ID]))</STRONG></P><P></P><P>or this</P><P></P><P><STRONG>Avg(Aggr(Avg(Days), [Customer ID]))</STRONG></P></BODY></HTML> Wed, 30 May 2018 11:13:04 GMT https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/30457#M771849 sunny_talwar 2018-05-30T11:13:04Z Re: Qlikview Expression https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/30458#M771850 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>Thanks a lot , you are always Right <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Second Condition works for my need.</P><P></P><P>Best Regards,</P><P>Hk</P></BODY></HTML> Wed, 30 May 2018 11:24:10 GMT https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/30458#M771850 dunnalahk123 2018-05-30T11:24:10Z