topic Re: calculated dimension in QlikView https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/14626#M789706 <HTML><HEAD></HEAD><BODY><P>It is creating a classification based on the difference in minutes between deliver date and login date, from 1 (less than 30 minutes difference) to 4 (over 3h difference). If all those fields are already on the same table in your datamodel, you can basically include this line in the script as a new field and use this new field as the dimension.</P><P></P><P>If not, you will have to ApplyMap() or JOIN, or elaborate on how your model looks like so we can further assist.</P></BODY></HTML> Tue, 13 Feb 2018 11:02:26 GMT Miguel_Angel_Baeyens 2018-02-13T11:02:26Z calculated dimension https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/14625#M789705 <HTML><HEAD></HEAD><BODY><P>Hi Expertise </P><P></P><P></P><P>Can you please explain me what is the below&nbsp; calculated dimension do ?</P><P></P><P></P><P>=if([Deliver_Date]-[logindate] &gt; 180, Dual('180+',4) ,if([Deliver_Date]-[logindate] &gt;90, Dual('90+',3), if([Deliver_Date]-[logindate] &gt; 30, Dual('30+',2), Dual('0-30',1) )))</P><P></P><P></P><P></P><P></P><P>This is really loading slow ..</P><P></P><P></P><P>how can i manage this in the script ?</P><P></P><P></P><P>Need help </P><P></P><P></P><P>Thanks in advance </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/14625#M789705 smilingjohn 2020-11-25T16:16:04Z Re: calculated dimension https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/14626#M789706 <HTML><HEAD></HEAD><BODY><P>It is creating a classification based on the difference in minutes between deliver date and login date, from 1 (less than 30 minutes difference) to 4 (over 3h difference). If all those fields are already on the same table in your datamodel, you can basically include this line in the script as a new field and use this new field as the dimension.</P><P></P><P>If not, you will have to ApplyMap() or JOIN, or elaborate on how your model looks like so we can further assist.</P></BODY></HTML> Tue, 13 Feb 2018 11:02:26 GMT https://community.qlik.com/t5/QlikView/calculated-dimension/m-p/14626#M789706 Miguel_Angel_Baeyens 2018-02-13T11:02:26Z